Hello,
First post and very new to VBAs.
I have several work sheets where there is data tab that needs refreshing every week. Later in the week I review and make changes. I've got a macro that automates the data refresh for me.
I'd like to automate the whole process so it runs over night Sunday to Monday so every time I open the sheet it's already up to date for me and refreshed the data.
What would be the best way to do this?
Thank you,
Hi, welcome to the forum.
If the file is already working and you have a macro that updates and closes the file you can use the Windows Scheduler to carry this out.
The folder and file needs to be accessible or if on a server triggered by a server account.
You can the have Excel open and execute that macro which will do the job for you.
Hope it makes sense.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks