Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Entry That Locks Selected Cells From Any Data Entry. ron Excel Worksheet Functions 5 February 16th 07 10:52 PM
how to query for the appearance of a data entry on multiple works. wriggg Excel Discussion (Misc queries) 0 July 31st 06 10:04 PM
Importing Data via Web Query - Can values be passed to query? [email protected] Excel Discussion (Misc queries) 5 May 9th 06 07:21 PM
Save data retreived from query without saving query Anthony Excel Discussion (Misc queries) 0 January 25th 06 08:17 PM
format data displayed on Excel data entry form Bob, too Setting up and Configuration of Excel 0 May 19th 05 09:26 PM


All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"