| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro from name stored in variable?
can you run a macro using its name stored in a variable? e.g.: ====================== *mName = "Macro1" Call mName * ======================== (I know the above doesn't work, but is there any similar method tha does work?)  Many thanks -- chubster26 ----------------------------------------------------------------------- chubster264's Profile: http://www.excelforum.com/member.php...fo&userid=3016 View this thread: http://www.excelforum.com/showthread.php?threadid=49846 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run macro from name stored in variable?
Use Application.Run.
Application.Run mName -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "chubster264" wrote in message ... can you run a macro using its name stored in a variable? e.g.: ====================== *mName = "Macro1" Call mName * ======================== (I know the above doesn't work, but is there any similar method that does work?) Many thanks. -- chubster264 ------------------------------------------------------------------------ chubster264's Profile: http://www.excelforum.com/member.php...o&userid=30164 View this thread: http://www.excelforum.com/showthread...hreadid=498463 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run macro from name stored in variable?
Thanks for the suggestion - I'm getting an error 1004 though when I run the code as below... Any further suggestions as to what might be the problem? Sub temp1() MsgBox "hello" End Sub --------------------- Sub trythemacro() Dim mName As String mName = "temp1" Application.Run (mName) End Sub -- chubster264 ------------------------------------------------------------------------ chubster264's Profile: http://www.excelforum.com/member.php...o&userid=30164 View this thread: http://www.excelforum.com/showthread...hreadid=498463 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run macro from name stored in variable?
Your code works fine for me. Try removing the parentheses from
the Application.Run statement. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "chubster264" wrote in message ... Thanks for the suggestion - I'm getting an error 1004 though when I run the code as below... Any further suggestions as to what might be the problem? Sub temp1() MsgBox "hello" End Sub --------------------- Sub trythemacro() Dim mName As String mName = "temp1" Application.Run (mName) End Sub -- chubster264 ------------------------------------------------------------------------ chubster264's Profile: http://www.excelforum.com/member.php...o&userid=30164 View this thread: http://www.excelforum.com/showthread...hreadid=498463 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run macro from name stored in variable?
I should have added that your called code must be in a regular
code module, not a sheet module, form module, or the ThisWorkbook code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... Your code works fine for me. Try removing the parentheses from the Application.Run statement. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "chubster264" wrote in message ... Thanks for the suggestion - I'm getting an error 1004 though when I run the code as below... Any further suggestions as to what might be the problem? Sub temp1() MsgBox "hello" End Sub --------------------- Sub trythemacro() Dim mName As String mName = "temp1" Application.Run (mName) End Sub -- chubster264 ------------------------------------------------------------------------ chubster264's Profile: http://www.excelforum.com/member.php...o&userid=30164 View this thread: http://www.excelforum.com/showthread...hreadid=498463 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run macro from name stored in variable?
Chip, Thanks so much! That nailed it. :) Chip Pearson Wrote: I should have added that your called code must be in a regular code module, not a sheet module, form module, or the ThisWorkbook code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com -- chubster26 ----------------------------------------------------------------------- chubster264's Profile: http://www.excelforum.com/member.php...fo&userid=3016 View this thread: http://www.excelforum.com/showthread.php?threadid=49846 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink, macro, stored procedure? | Excel Worksheet Functions | |||
| Run SQL Server stored procedure in Excel macro | Excel Programming | |||
| variable stored in Excel - read only from VBA | Excel Programming | |||
| How to call a stored procedure in a macro | Excel Programming | |||
| Where is a macro shortcut key stored in a module? | Excel Programming | |||
Linear Mode
