I love your program!!! But - I have a few teething problems with it. Perhaps someone might set me straight?
I would like to do a results scan on Google for selected keywords, and I thus recorded/edited the macro below. It does what I want it to but only to a point.
The idea is to enter a keyword (ideally from a list, but for now, just manually, one by one), then copy/paste the broad-match result from Google, then also copy/paste the phrase-match - into a spreadsheet.
The problem I have is that I've tried using a text-formated list with a keyword written per line and I can't seem to be able to get it to work, not even to read it. Also, I'm having a problem understanding the nature of the loop here, i.e. should I enter a loop number (but then what if the list is shorter or longer than the entered number?) or is there a way to do a while-loop, i.e. until the list is finished?
Could you have a look at the script below and tell me how to modify it for it to work with a list which is stored as, say, C:\mykeywordlist.txt ?
cheers
paul{{' Created at: Aug.29.2011, 16:25 (MKR Version: 6.7 )
{{' set up text variable StringText01 the "keyword" can be anything - this should be a txt file with lots of keywords in it
{{SetStringText01 keyword
{{' switch to Firefox and make a new tab, then start google.com - not sure how to check if it's already open and if not, to open it
{{Switch Mozilla Firefox
^t
google.com
{ENTER}
{{' enter the keyword using StringText01variable - or take it from the txt file one by one
{{Delay 1500}
{{StringText01}
{ENTER}
{{' locate broad-match result number and copy that number to clipboard
{{Delay 1500}
^f
results
{ESC}
+{HOME}
^c
{{' switch to Excel and create a new worksheet - not sure how to check if excel is open already and if not, to open it
{{Switch Microsoft Excel
^n
{{' write the variable name of the keyword in first cell
{{StringText}
{TAB}
{{' then paste the broad-match results in the next cell to the right
^v
{TAB}
{{' switch to Firefox and click on the search field
{{Switch Mozilla Firefox
{{Mouse 1, 1, 312, 752, 0
{{RelativeMouse Mozilla Firefox, 1, 1, 379, 228, 0
{{' add quotation marks for phrase results at beginning and end of keyword
å
{HOME}
å
{END}
{{NumPadEnter}
{{Mouse 1, 1, 301, 757, 0
{{' locate phrase-match results number and copy that number to clipboard
{{Switch Mozilla Firefox
{{Delay 1500}
+{HOME}
^f
results
{ESC}
+{HOME}
{{Delay 500}
^c
{{' switch to the new Excel spreadsheet
{{Switch Book
{{' now paste the result of the phrase match
^v
{ENTER}
{{' now remove the åAboutå string from the cells
^h
%n
About
{TAB}
{DELETE}
%a
{{NumPadEnter}
{ESC}