Schedule A Macro To Run With Scheduled Tasks

General Macro Scheduler discussion

Moderators: Dorian (MJT support), JRL

Post Reply
Carmelo Labadie
Newbie
Posts: 2
Joined: Fri Jul 02, 2021 7:30 am

Schedule A Macro To Run With Scheduled Tasks

Post by Carmelo Labadie » Fri Jul 02, 2021 5:05 pm

I have a worksheet that runs a query from an external data program. I have made a macro that refreshes the worksheet and this works ok. Is there a way I can get Scheduled tasks to automatically update this workbook eg overnight. I do not want to leave the workbook open either. Can task scheduler open the workbook, refresh the data, then close the workbook again.


Please help

Thanks

User avatar
Dorian (MJT support)
Automation Wizard
Posts: 1348
Joined: Sun Nov 03, 2002 3:19 am
Contact:

Re: Schedule A Macro To Run With Scheduled Tasks

Post by Dorian (MJT support) » Fri Jul 02, 2021 5:44 pm

Yes of course.

Simply open it with XLOpen (as you may already be doing), and after it's finished processing use XLSave and XLQuit.
Yes, we have a Custom Scripting Service. Message me or go here

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts