Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run (WorkBook.Name & "!MacroName")
Hello,
I hope you could help me with my recent problem... I'm running a vbcode form from my Personal.xls and trying to access a macro from another workbook but I can't open/run the macro... I'm getting error "The macro .......... can't be found" The macro though exists on the other workbook I'm trying to run the macro from... Please help Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run (WorkBook.Name & "!MacroName")
Try:
Application.Run ("'" & WorkBook.Name & "'!MacroName") HTH, Ken Puls, CMA, Microsoft MVP (Excel) www.excelguru.ca Marve wrote: Hello, I hope you could help me with my recent problem... I'm running a vbcode form from my Personal.xls and trying to access a macro from another workbook but I can't open/run the macro... I'm getting error "The macro ......... can't be found" The macro though exists on the other workbook I'm trying to run the macro from... Please help Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run (WorkBook.Name & "!MacroName")
Hi Ken,
It Works!!!! Thanks a lot for the help! I really appreciate it.. Cheers, Marve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming | |||
Application.Run("MacroName", Args) | Excel Programming | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |