run macro from command prompt

[uniks]

hi everyone,
i want to run my code in excel vba by using cmd (command prompt).
i've tried some code that i get from the internet but it still didn't work.
is it really possible?
here is my macro

Please Login or Register  to view this content.

And here is my code

Please Login or Register  to view this content.

Thanks

[berlan]

I don't follow. Could you explain further? What's the RunMacro code in z.xlsm for?

[S O]

Is there a particular reason you want to do this in CMD? It would be easier from WScript or Powershell...

[uniks]

@berlan : Module.RunMacro is the script to run the macro in z.xlsm from vbs. That's what i read on the internet. Thanks
@ S O : yeah, because in the future i want to make some programs that run automatically by using task scheduler in windows. But if WScript or Powershell could do it, then i'll have to try them as well. Thanks

[S O]

You can use the code you've got up there in a VBScript, it should literally copy and paste over with no issues - you can then run the VBS file from task scheduler, or even call it from CMD like:

Please Login or Register  to view this content.

[uniks]

i've tried my code above but it just open the workbook and didn't run the macro.
how do i make the code run my macro?
by the way could u post the WScript and Powershell script so i could try and compare them.
and is it possible just to run the macro without opening the "excel" file
Thanks

[uniks]

after some research this is the code that work

Please Login or Register  to view this content.

note : i run this code from Powershell so you have to save it in a '.PS1' file to run it