| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a Sub created on the fly
I can write code to add a code module to a project and place desired code
into that module. However, I cannot call a sub in that module - it fails at compile time because, at that time, it is undefined. How can I accomplish this? I'm sure this question has been answered many times, but I haven't found a solution. Many thanks for your help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling a Sub created on the fly
Application.run "SubName"[,parameters]
On Wed, 23 Nov 2011 09:22:56 -0500, wrote: I can write code to add a code module to a project and place desired code into that module. However, I cannot call a sub in that module - it fails at compile time because, at that time, it is undefined. How can I accomplish this? I'm sure this question has been answered many times, but I haven't found a solution. Many thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calling a sub | Excel Programming | |||
| I have a fix already, but would like to use what I've created here | Excel Programming | |||
| calling a method on an object created in a different addin | Excel Programming | |||
| Calling for pages before they are created. | Excel Discussion (Misc queries) | |||
| Calling an Excel/VBA User Created Module from WSH | Excel Programming | |||
Hybrid Mode
