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

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" <daytonsupply@discussions.microsoft.com> wrote in message
news:D33180B0-0E34-44EB-BF46-1389C754E38C@microsoft.com...
> 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
>