Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call macro from other workbook
hi all !!
i know this command for calling a macro from another workbook.. Application.Run (Macrobook!Macroname) now.. i need a more complex task.. i need to call the macro "MyMacro" .. in all the open workbook that have it .. or , in all the workbooks wich name begins with Z, for example.. ...open workbooks change name every week, because i change some, so i cant correct code evry time, and i need any wild character like *.* doing the work for me... is there any way for doing that ?!? that would give to my work right control of flux. ty !! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call macro from other workbook
For Each wb In Workbooks
If ucase(left(wb.name,1) )= "Z" Then 'your code End if Next wb -- Steve "pls123" wrote in message ... hi all !! i know this command for calling a macro from another workbook.. Application.Run (Macrobook!Macroname) now.. i need a more complex task.. i need to call the macro "MyMacro" .. in all the open workbook that have it .. or , in all the workbooks wich name begins with Z, for example.. ..open workbooks change name every week, because i change some, so i cant correct code evry time, and i need any wild character like *.* doing the work for me... is there any way for doing that ?!? that would give to my work right control of flux. ty !! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call macro from other workbook
hi steve ! ty ! i will test this soon !!
"AltaEgo" wrote: For Each wb In Workbooks If ucase(left(wb.name,1) )= "Z" Then 'your code End if Next wb -- Steve "pls123" wrote in message ... hi all !! i know this command for calling a macro from another workbook.. Application.Run (Macrobook!Macroname) now.. i need a more complex task.. i need to call the macro "MyMacro" .. in all the open workbook that have it .. or , in all the workbooks wich name begins with Z, for example.. ..open workbooks change name every week, because i change some, so i cant correct code evry time, and i need any wild character like *.* doing the work for me... is there any way for doing that ?!? that would give to my work right control of flux. ty !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from? | Excel Programming | |||
need macro to call a workbook w/o the actual name of the workbook | Excel Programming | |||
Call macro stored in Excel workbook from Outlook's macro | Excel Programming | |||
Call Macro from another WorkBook? | Excel Programming | |||
Call a macro in other workbook | Excel Programming |