ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ExecuteExcel4Macro: Help with this (https://www.excelbanter.com/excel-programming/299031-executeexcel4macro-help.html)

Shilps

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