I have read a little about Excel being able to perform web queries.
Can this be done for item specific details?
My idea is to create a list of items that I want to find details about and run the query, then depending on how many I find either automatically download these details or wait for instructions.
Is this possible?
Hi Yelp ,
Have you looked at the entries on Google in the KB?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
No,
I will head there now.... thx
MD,
In this KB entry:
Searching Google by Excel , http://vbaexpress.com/kb/getarticle.php?kb_id=291
After right-click in #4, #5 instructs to double-click, but the sub-menu opens. I don't see what there is to double-click and does "plan" mean one of the objects in the Project?(4. Right-click desired file on left (in bold).
5. Double-click the plan where you want to have the ComboBox control)
Or does plan mean Worksheet?
I think Plan just means sheet. I tried the sample file and found some problems with it. Basically unwanted quote marks. Try this version.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Problem with web queries is in password controlled pages, they are a nightmare to control from VB.
xld, this is a general statement about web queries and not me getting it setup, correct?
A general statement Doug, but one you will run into if you try and extend it to such sites. The problem is that most web queries work fine if the page is open and you cab issue a URL direct to the browser, but when that URL throws up a password dialog, passing that information through, even if you know it is horrible.
Posting Permissions
Reply With Quote
