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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top