excel macro excecution from command line via bat file?
 

Is there a way to open an excel workbook and launch a macro from
within a BAT file? I know this can be done with access as seen in the
example below.
__________________________________________________ ____________________________
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "\
\brsrv001\vol2\SHARED.DOC\backlog\DG_Capacity.mdb" /nostartup /x
WeeklyUpdate

Exit
__________________________________________________ ____________________________

Is there a similiar option for excel?

excel macro excecution from command line via bat file?
 

On Jul 12, 9:43 am, Ted wrote:
Is there a way to open an excel workbook and launch a macro from
within a BAT file? I know this can be done with access as seen in the
example below.
__________________________________________________ _________________________*___
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "\
\brsrv001\vol2\SHARED.DOC\backlog\DG_Capacity.mdb" /nostartup /x
WeeklyUpdate

Exit
__________________________________________________ _________________________*___

Is there a similiar option for excel?

Never mind the previous, instead, how do i setup a default macro to
run when a particular workbook is open?

excel macro excecution from command line via bat file?
 

Ted

Private Sub Workbook_Open()
macroname or code goes here
End Sub

Entered in Thisworkbook module.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 09:42:24 -0700, Ted wrote:

On Jul 12, 9:43 am, Ted wrote:
Is there a way to open an excel workbook and launch a macro from
within a BAT file? I know this can be done with access as seen in the
example below.
__________________________________________________ _________________________*___
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "\
\brsrv001\vol2\SHARED.DOC\backlog\DG_Capacity.mdb" /nostartup /x
WeeklyUpdate

Exit
__________________________________________________ _________________________*___

Is there a similiar option for excel?

Never mind the previous, instead, how do i setup a default macro to
run when a particular workbook is open?