I have a small task to do.
My excel file is linked to SQL thru ODBC. Whenever i open file its set to refresh automatically.
All i need to do is open the file daily at a scheduled time, then wait for a minute or two to get it refreshed automatically and then close it.
I have been googling a lot but couldn't find a solution to this problem.
Thanks in Advance.
My excel file is linked to SQL thru ODBC. Whenever i open file its set to refresh automatically.
All i need to do is open the file daily at a scheduled time, then wait for a minute or two to get it refreshed automatically and then close it.
I have been googling a lot but couldn't find a solution to this problem.
Thanks in Advance.