Is there a way to pass parameters to a web query in excel

D

daytonsupply

I need to pass data from a cell in excel to a form on a web page and need to
get the data created by the web page back into excel. Eg. row 1 in excel
worksheet has a part number for an item. I would like to be able to create a
web query that will go onto the web, pass the partnumber the webpage, and
retrieve the description and current pricing for the item. Is this possible
in excel? How do i get started?

Thanks,

Jay Woessner
DST
Dayton, Ohio
 
T

Tom Ogilvy

Turn on the macro recorder while you perform the web query manually (through
Excel's data=>Get external data or import exteranl data)

Then turn off the recorder.

Look at the code recorded and you can substitute references to your cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pass parameters to excel from wscript (Windows script) 5
Passing parameters to a Web Query 1
Excel Web Query 1
Pass parameters to Workbook from hyperlink 2
Trying to create a list of prices from a web page 1
Query from Excel to Access - Passing Parameters? 8
web query and formatting 0
download info from a web site to Excel 3

Top