ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Application.Run in VBA (https://www.excelbanter.com/excel-programming/288247-using-application-run-vba.html)

Jag Man

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