Calling XLA Macro from DLL.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a XLA Add-in that loads a XLL DLL using Microsoft Excel C API.

How can I call a Macro in the XLA file from the DLL?

I have tried to use the xlUDF function, but without success.

Anyone have suggestions on how I can proceed?

Thanks in advance /T
 
Hi

We have reviewed this issue and are currently researching on it. We will
update you ASAP. Thanks for your patience!

Kevin Yu
Microsoft Online Community Support
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Hi,

Since XLL CAPI is an old technology to extending Excel function.

Currently I am still trying to find the related document.
Also I will update you with new information ASAP.
Thanks!

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi,

You may try the approach below.
1. Call Excel4() (or Excel12() if you're in Excel 2007) and invoke xlfRun.
2. For the 1st arg, pass in an XLOPER of xltypeStr that contains the
fully-qualified name of the macro you want to run.

Please let me know if that did not work for you together with the exact
error code/message or error scenario description.

Thanks!

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top