![]() |
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 |
All times are GMT +1. The time now is 01:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com