Chart Doesn't Appear when Excel started from Command Line

  • Thread starter Thread starter mitchamm
  • Start date Start date
M

mitchamm

I have a Excel Workbook which creates a chart from a text file when the
Workbook is opened by using a Macro. This works fine, however, when I
use a Command from the Windows Command LIne to open the workbook the
Chart doesn't appear.

This only happens with Excel 2002. If I use Excel 97 or 2000
everything works fine.

Does anyone know of a solution to this problem???
 
Is Excel 2002 set up to ignore macros (high security setting)? It won't
even warn you that there's a macro, it just skips it.

- Jon
 
Are they Auto_Open macros? ISTR that you need to explicitly run them
when opening the workbook in code, while the Workbook_Open event
procedures run as expected.

A search of the groups in google turned up this link

http://groups.google.com/[email protected]

which gives this code:

Workbooks.Open "ANALYSIS.XLS"
ActiveWorkbook.RunAutoMacros xlAutoOpen

A follow up post suggests putting the code from the AutoOpen procedure
into a Workbook_Open procedure in the ThisWorkbook class module.

- Jon
 
Back
Top