ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing Query to get external data (https://www.excelbanter.com/excel-discussion-misc-queries/175286-changing-query-get-external-data.html)

Andyjim

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

joel

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



All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com