ExcelBanter - Get External Data Web Query new worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Get External Data Web Query new worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/22016-get-external-data-web-query-new-worksheet.html)

Nina

Get External Data Web Query new worksheet

How can I use the Get External Data Web Query to save to a new worksheet or
file rather than just REFRESH the data it gets from a webpage.
I need to get 24 hour data from a webpage that ONLY shows the past 12 hours.
I would like to use the Get External Data twice a day to automatically save
the data to a new file or worksheet. Any Suggestions?

All times are GMT +1. The time now is 03:49 PM.