Running Excel Macros in Batch Mode

[bomvoo]

I need to run an excel spreadsheet macro from command line. Is this possible?

I've been able to open a specific spreadsheet by typing at the command line (from command window prompt):

excel 'path and name of the spreadsheet '

I had to add the path to the excel executable file folder to the environmental variable PATH.

Is there an additional command that opens a given spreadsheet and runs a specific macro inside that spreadsheet all at once?

Thank you in advance

Eduardo

 

[VoG]

If you name the macro

Sub Autpen()

it should run automatically.