Web Scraping

**Thomo88** · 04-28-2014, 12:03 PM

Hi

I am looking for some much needed help with the below code. My aim open a website, populate the html fields on that site with values defined in my excel sheet, then extract the results found on the website, back into excel ... ie search an auction site for an item, then search results back to excel.

So far I am have been able to get the below code to launch site, populate required fields and return search results ... but I am struggling to now return the results back to targeted columns within excel??

The overall aim of this exercise is to develop an excel tool that will allow scenario testing of a website / website scraping.

Current Code:

Please Login or Register  to view this content.

Thank you in advance for any information you can provide ... will be VERY much appreciated!

As always, apologies if this has already been posted

Regards
Ben

**Thomo88** · 04-29-2014, 07:21 AM

for anyone who has previously seen this thread, I have revised my initial post (and updated the code to the current version that I am now using) as I have now been able to work out stage one of the process ... populating site fields and initiating the search. My current problem is now return the search results into excel.

Thanks