moving Excel Sheets

[gregpet]

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

[Marcus Tettmar]

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