Hi all,

Im trying to automate the process of an MSQuery within Excel and then output to an html page. Am I correct in thinking you cant setup an external data connection to a spreadsheet with an htm extension?

If you can - how would I automate this to pull the data through say every 5 minutes? If I cant is it a process of having a xlsx sheet pulling hte data and then output that to an htm file and overwriting each time?

Thanks