Call VB6 DLL from Worksheet without VBA wrapper

[Lawrence]

Can anyone tell me how to call compiled VB6 function directly from a
cell in Excel worksheet, without creating a VBA function as a wrapper.
Using a VBA wrapper causes a serious execution time overhead compared
to built-n excel functions.

Thanks,

Lawrence

 

[Rob Bovey]

Hi Lawrence,

This is only possible using a special type of add-in called an
Automation add-in that is only supported by Excel 2002 and higher. For
versions of Excel prior to 2002, you must use a VBA wrapper in order to call
a function in a VB6 DLL.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Rob Bovey]

Hi Lawrence,

I honestly haven't timed Automation add-in functions, and I'm surprised
to hear that they don't provide a significant speed improvement given that
they allow you to bypass VBA altogether. However, if you need native
function speed, there's really only one way to get it, and that's to write
your functions in an XLL using C/C++ and the Excel C API.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *