 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / February 2008web 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! Use a worksheet_change event If you give the url etc, I will try to help  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > 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! Sure, it is www.officedepot.com Thanks much! Z > Use a worksheet_change event > If you give the url etc, I will try to help [quoted text clipped - 3 lines] > > 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! Would you care to be a bit more specific. I would imagine its a large site. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Sure, it is www.officedepot.com > [quoted text clipped - 9 lines] >> > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.