PDA

View Full Version : Set up table to search Web for specific Item details



YellowLabPro
04-09-2007, 04:49 AM
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?

mdmackillop
04-09-2007, 04:54 AM
Hi Yelp ,
Have you looked at the entries on Google in the KB?

YellowLabPro
04-09-2007, 04:56 AM
No,
I will head there now.... thx

YellowLabPro
04-09-2007, 05:16 AM
MD,
In this KB entry:
Searching Google by Excel , http://vbaexpress.com/kb/getarticle.php?kb_id=291



(4. Right-click desired file on left (in bold).
5. Double-click the plan where you want to have the ComboBox control)


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?

YellowLabPro
04-09-2007, 05:27 AM
Or does plan mean Worksheet?

mdmackillop
04-09-2007, 06:14 AM
I think Plan just means sheet. I tried the sample file and found some problems with it. Basically unwanted quote marks. Try this version.

Bob Phillips
04-09-2007, 07:27 AM
Problem with web queries is in password controlled pages, they are a nightmare to control from VB.

YellowLabPro
04-09-2007, 07:32 AM
xld, this is a general statement about web queries and not me getting it setup, correct?

Bob Phillips
04-09-2007, 09:07 AM
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.