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

By jeby ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums