Template to automatically run web query

  • Thread starter Thread starter Ahmed Mesbah
  • Start date Start date
A

Ahmed Mesbah

I repeatedly open a blank spreadsheet and run a web query to retrieve
external data from a particular web page. I then use autofilter to filter
the results. Is it possible to automate this. Ideally, what I would like to
happen is to open the template, have it automatically query the web page,
download the data and then turn autofilter on.

Thanks in advance.

Ahmed
 
I don'tr know if this will work but have you tried saving it as a Macro?

Otherwise I guess you will need a VB whizz.
 
Back
Top