VBScript to Open File and Execute Macro in Personal Workbook Module

[jlockman]

I am having trouble writing a VBScript file to replicate a macro that I manually trigger at the same time each day. I have tried tweaking several examples provided but none of them quite work for my situation. My objective it o schedule a batch file in Task Scheduler to run a script which would open a workbook with predefined path/name and trigger a macro saved in my Personal Workbook (it's in Module 18 if that matters). This workbook is one that I download daily so I cannot save the macro in the workbook itself, which is why it is saved in Personal Workbook. Usually I open this workbook manually (personal workbook also opens but is hidden) and use Control H to manually trigger my macro (macro is PERSONAL.XLSB!Helper_Sheet). Can someone please help with a vbs script code for this?

 

[nhill95]

Hello! Did you ever get an answer to this problem?? I am experiencing the same issue and can't find any where else on the internet where someone is also having this problem. Thank you!!!

 

[jlockman]

I did not... my workaround has been to use Macro Recorder. I used Macro Recorder to create a macro to launch the URL, download the file, automatically open that file, execute the keystroke to run my Excel macro, close the file, then close the browser window. I use Task Scheduler to run that Macro Recorder macro. It's not the workflow that I preferred, but it's getting the job done.