View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shilps Shilps is offline
external usenet poster
 
Posts: 36
Default 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