web query when data entry
 

Hi, how do I cause a web query to execute when I enter data into a particular
cell? i.e. when I type an item code into the cell, the query goes to a
vendor web site and retrieves its price, name, etc. thanks much!

web query when data entry
 

Use a worksheet_change event
If you give the url etc, I will try to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zack L" wrote in message
...
Hi, how do I cause a web query to execute when I enter data into a
particular
cell? i.e. when I type an item code into the cell, the query goes to a
vendor web site and retrieves its price, name, etc. thanks much!

web query when data entry
 

Sure, it is www.officedepot.com

Thanks much!

Z

"Don Guillett" wrote:

Use a worksheet_change event
If you give the url etc, I will try to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zack L" wrote in message
...
Hi, how do I cause a web query to execute when I enter data into a
particular
cell? i.e. when I type an item code into the cell, the query goes to a
vendor web site and retrieves its price, name, etc. thanks much!

web query when data entry
 

Would you care to be a bit more specific. I would imagine its a large site.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zack L" wrote in message
...
Sure, it is www.officedepot.com

Thanks much!

Z

"Don Guillett" wrote:

Use a worksheet_change event
If you give the url etc, I will try to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zack L" wrote in message
...
Hi, how do I cause a web query to execute when I enter data into a
particular
cell? i.e. when I type an item code into the cell, the query goes to a
vendor web site and retrieves its price, name, etc. thanks much!