View Single Post
  #1   Report Post  
Nina
 
Posts: n/a
Default 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?