![]() |
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 |
All times are GMT +1. The time now is 10:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com