Hello guys,
I have 10 excel workbooks which are connected on warehouse database (ODBC connection). I know to make these excel files to refresh on open or every 5h, but I need schedule refresh every Sunday at 4 PM for example.
Is it possible to do this with some macro within excel or there is some better solution?
Thanks in advance.
Last edited by toci; 03-23-2017 at 07:54 AM.
Personally I would make a book with on open code that opens the workbooks that need refreshing (which refresh themselves on open?), then close them again. Then use the task scheduler in windows to open that workbook on sundays at 4 pm.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Can you help me with this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks