ExecuteExcel4Macro: Help with this
Hi
I recorded a new macro and its code comes out to b
ActiveChart.SeriesCollection(3).Points(3).Selec
Windows("2_X_2_Matrix.xls").SmallScroll ToRight:=1
ExecuteExcel4Macro "EDIT.SERIES(3,,,""=Design!R2C34:R4C34"",,3)
Now the help for this method says
The Microsoft Excel 4.0 macro isn't evaluated in the context of the current workbook or sheet. This means that any references should be external and should specify an explicit workbook name. For example, to run the Microsoft Excel 4.0 macro "My_Macro" in Book1 you must use "Book1!My_Macro()". If you don't specify the workbook name, this method fails
But in the macro recorded, I do not see any reference. Why
Thank
Shilps
|