98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Web Query
Web Query
Resolved · High Priority · Version 2003
Mon 26 Oct 2009, 16:15Delegate David said...
David has attended:
Access Advanced course
Web Query
Hi
I use a web query to download tables from a web site which populates a worksheet which works fine. However one of the tables is quite a big table but I only actually need two rows from the table for my data anaylsis.
Is it possible to write a web query which only brings back certain rows from a web table?
Regards
Dave
Wed 28 Oct 2009, 10:00Trainer Stephen said...
RE: Web Query
Hi Dave
Thanks for the question
I'm pretty certain that the answer to your question is no. I have investigated the web query tool and I can see no facility for filtering the data. It would also on reflection be difficult to do as tables on a web site often lack column headings (field names) so it would be difficult to identify columns to filter.
I will however continue to explore things and if I find anything different I will let you know
Regards
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Stop Formula Returning A "#DIV/0" ErrorIf a formula returns a #DIV/0 error message there is a way to avoid such results. |
