gotteeth

Steve,

I have not had time to play with this. I just quickly read the post.

Please PM me so I can send you some beer money.

I really appreciate your time and input on this. This is something that's been on my "to-do" list for a long time, and not having a way to retrieve the data I need has really slowed me down.

I'll go over this this weekend and see if I can make it work without screwing it up

Cheers!

Mike

Portland, Oregon

This shouldn't be too difficult (if you've played with ME for a while), and I'd be happy to help you build the macro you need. But I need just a little more informaiton. Specifically, when you say: "...with the values from each search copied from google and pasted to the excel file." To what values are you referring?

 

Also you say there needs to be a random time delay or at least 5 seconds between each search. Is that in addition to the time required for the macro to perform the Google search, collect the information, and save it to the Excel file? If so, why does there need to be an additional 5 seconds?

Thanks for your help on this.

1. The "values" I'm referring to are the search results that show in google after the search. Example: go to google and do a search for the word banana, look in the upper right side of the results in google, you'll see "Results 1 - 10 of about 58,200,000 for banana." I'm after the value, that in this example, is 58,200,000.

2.The delay I spoke about is needed only because google sees fast, repetitive queries as automated and will respond by requiring a captcha be filled in before it responds. It's a pain in the rear and can be avoided by going slow with the query speed. I'm going to be searching for small amounts of data so this shouldn't be too much of an issue.

Does that better explain it?

Thank you so much for your input/help.

Cheers!

Mike

Hello,

Thanks in advance for any help offered.

I have Macro Express and I need to create a macro but what I need is out of my experince level and I don't have the time to figure it out.

I need advice on how to get this done and what a reasonable price for payment would be.

The macro would need to start from an open excel file. There will be a random number of keywords in the file, one keyword phrase on each line...

bannanas

green bannanas

blue bannanas

I need the macro to highlight each of those keyword phrases individually, go to google and type it in the search box. I will need four different searches for each keyword phrase, with the values from each search copied from google and pasted to the excel file.

Here is what the searches will be:

"bannanas"

intitle:”bannanas” inanchor:”bannanas”

site:squidoo.com intitle:"bannanas" inanchor:"bannanas"

site:hubpages.com intitle:"bannanas" inanchor:"bannanas"

There needs to be a random time delay between each search, or at least 5 seconds.

The above seems possible with MacroExpress...I just don't know how to set it up.

Thanks again for any help.