Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
ExecuteExcel4Macro Page.Setup Runtime Error | Excel Programming |