I am working on a problem where I have a list of about 200 titles that I need to enter into a website and then copy and paste the results that are displayed. The good news is the results are in a consistent format.
Is there any way to record a macro to do this.
Ideally, I would like to record a macro in such a way that it understands each of the steps required to collect all of the data, then let it work its way down the list of 200 data points.
What do you think.
Do you mean you want Excel to copy data from cells to the web and then copy and paste something back from the web? If so, I doubt that you'll be able to do that, not even with VBA.
No i want excel to select a piece of data to input into a websearch from a list provided in excel. Then copy and paste the results that the websearch produces.
Has anyone got an answer to this thread
Veejar,
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks