Question Locked

Excel 2007 Web Query - Want to query site not just page

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a website that sells product from a vendor (will provide website name if requested). The vendor's website does not expose a table of updated stock status and prices, but rather lists one product per page on the site. There are 2 fields on each page that I need to import into a spreadsheet using the item number listed on the page. When querying for an item number, I need the stock status and retail price returned. I want it to query all of my items overnight so I can upload the new stock status. I'm trying to use the Excel .iqy file but I'm having no luck. Has anyone tackled this problem?

All help appreciated.

1 reply

This discussion is closed to new replies.