I need a VBA or perl script to automate process using excel and a website.
Here is a brief summary of the process that needs to be automated with the script. A word is given by the user and he enters it into the first column of the excel sheet. He goes to a website that has a keyword generator he puts the keyword into. This website will give lateral variations (about 300 variations) of that original keyword. Now the user copies all these variations and puts in into the excel sheet at the second column. The user then clicks on each of the 300 variations on the results page of the website and will get back anywhere from 100 to 300 words for that keyword he clicks on (these are further variations of the word). The user will then copy these "deep" variations into the excel sheet with the first column being the main word, second being the variation of the main, and pastes these "deep" variations on the third column. The user continues to click and copy these deep variations for all the variations from the original keyword until it is done. SO the resulting excel sheet will look like this when the word Apple is the main starting keyword:
col1 (main word) Column (variation 1) column 3(deep variation)
apple apple apple sauce
apple apple apple cake
apple apple apple salad
apple . .
apple . .
apple . .
apple bannana bannana sauce
apple bannana bannana yellow
apple bannana bannana cider
apple . .
apple . .
... ... ....
apple zucchini zucchini pie
apple zucchini zucchini cook
apple zucchini zucchini ice
The script needs to work for windows 2000/xp and have a simple "click to run" interface with a pause button. The inputs are the main keyword, website to get the word variations (user and pass need for the members site). The outputs is an excel sheet with 3 columns - main input word, variation 1 words, and deep variation words.
The website address where these words are generated will be given to the programmer. Programmer needs to be able to communicate well in english. Thanks and happy holidays!