Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Application.Run in VBA
VBA Help gives a syntax:
expression.Run(Macro, Arg1, Arg2, ...) whe Macro Required Variant for Syntax 1 (not used with Syntax 2). The macro to run. This can be either a string with the macro name, a Range object indicating where the function is, or a register ID for a registered DLL (XLL) function. If a string is used, the string will be evaluated in the context of the active sheet. I have not been able to make this work for functions that I write and put in a DLL. Most likely, my problem is I don't know exactly what " a register ID for a registered DLL (XLL) function" means. How does one "register" a DLL function in the sense used here? TIA Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA-Application | Excel Discussion (Misc queries) | |||
Application Look | Excel Discussion (Misc queries) | |||
Application.run | New Users to Excel | |||
macro to close excel application other than application.quit | Excel Programming | |||
application.quit will not shut off application | Excel Programming |