Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to pass on different parameters to VBA Code? | Excel Worksheet Functions | |||
How to pass a date in Excel to ms query | Excel Programming | |||
Pass multiple parameters through macros | Excel Programming | |||
Starting Excel from cmd pmpt, pass parameters | Excel Programming |