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

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

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

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.

--
Regards,
Tom Ogilvy

"daytonsupply" wrote in message
...
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