-
Refresh Tables at Specified Time
I have an excel workbook that has three tables linked via SQL Server. Right now, the data is refreshed when the user opens the file. Due to the large tables, it can take a minute or two before the refresh in done. Is there VBA code that I can use to refresh all my tables at a specific time (6:30 am) of the day without the user actually opening the file?
Thank You!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules