Start Excel2000 including a makro

[Lars]

Start Excel2000 including a makro

like Excel.exe c:\..\bok1 makro1 The makro will start autm without press
makro button

Thanks

Lars

 

[Gord Dibben]

Lars

You can't run a macro from a command line but you can run a macro when the
workbook opens.

Private Sub Workbook_Open()
Your Code or macro name goes here
End Sub

Right-click on the Excel logo left of "File" on menu and select "View Code"
If workbook is not maximized click on the Logo on the title bar.

Paste the above into that module.

Command line will read C:\....yourpath\file name


Gord Dibben MS Excel MVP