I have an ODBC query in an Excel spreadsheet.
It refreshes on file open.
I would like to be able to have it refresh and save by a scheduled task. Any ideas?
This is a spreadhseet that will be going to management weekly. They don’t have ODBC setup on their machines so I would like to disable ‘refresh on open’ and have a scheduled task to refresh before my scheduled task to email it out. Currently I just have to open the doc, save and close each week before the email-out task runs. I can’t seem to find a command prompt (Win2K) command to launch, refresh, save and close. I also tried open and close by PERL script but it doesn’t do the refresh so it’s useless to me.