moving Excel Sheets

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
gregpet
Newbie
Posts: 13
Joined: Wed May 22, 2013 8:11 pm

moving Excel Sheets

Post by gregpet » Fri Mar 09, 2018 3:38 pm

I have a macro that creates 5 csv file reports each day. I want to open those in Excel and move them all to one sheet. Can that be done with Macro Scheduler or do I need to do this in Excel VBA. Any code hints in either would be appreciated. The names of the files change each day.

Thanks

User avatar
Marcus Tettmar
Site Admin
Posts: 7378
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: moving Excel Sheets

Post by Marcus Tettmar » Fri Mar 09, 2018 7:27 pm

There are no native functions to do that but you can convert VBA to VBScript and run VBScript inside Macro Scheduler. Therefore anything you can do inside Excel you can run from Macro Scheduler. Another option is that you can create a VBA macro inside Excel and run it with the native XLRun command.

If you want to convert VBA to VBScript to run inside Macro Scheduler take a look at this:
https://help.mjtnet.com/article/19-conv ... o-vbscript
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

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