Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Query to get external data
Hi-
Could someone explain the mechanics of editing an existing query that gets investment quotes from the Internet. This site has changed their table and we need to change our query accordingly. I thought perhaps just delete the existing query and start again, but I haven't figured out how to do that. Thanks for your help. Andy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Query to get external data
To remove a query go to Files - Properties - Custom on the worksheet menu.
Add query Data - Import External Data - New Web Query. Then put webpage URL into address bar. "Andyjim" wrote: Hi- Could someone explain the mechanics of editing an existing query that gets investment quotes from the Internet. This site has changed their table and we need to change our query accordingly. I thought perhaps just delete the existing query and start again, but I haven't figured out how to do that. Thanks for your help. Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import external data - web query | Excel Discussion (Misc queries) | |||
Import Data -- External Web Query | Excel Worksheet Functions | |||
External Data Query | Excel Discussion (Misc queries) | |||
Get External Data-New Web Query | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) |