AnsweredAssumed Answered

Running Excel Macro using Dispatch

Question asked by Derek Bessette on Mar 6, 2010
Latest reply on Mar 8, 2010 by Derek Bessette

I am trying to auto create a PDF of Excel documents upon a state transition using dispatch.  I have the excel macro working properly and have stored in in the Personal workbook.  The dispatch will open the excel document but does not run the macro.  Here is the shell execute command I am running.

 

 

Any ideas why the macro does not run.  Am I storing the macro in the wrong place?image001.png

Outcomes