UDF's via Automation Addin in Excel 2010?

[Ralf Steinstraesser]

Hi,

does anybody know about the compatibility of Excel 2010 with User Defined
Functions via the Automation addin model. We had developed a plugin, which
was working fine with Office 2007 and below. Now, the UDFs are not available,
if you run it in Excel 2010. This is Office 2010 beta on Windows7 64 bit
(have not tried 32 bit).

Best regards

 

[Charles Williams]

You don't say if you are using Excel 2010 64bit or 32 bit (they both run OK
under Win 7 64).

My automation addin UDFs work fine under XL 2010 32bit, but do not work
under XL 2010 64bit because they use compiled VB6 which produces a 32-bit
DLL:
Automation addins with Excel 2010 64bit require a 64-bit DLL and VB6 cannot
produce one, so VB6 Automation addins need to be converted to another
language that can run in 64-bit mode.

See http://msdn.microsoft.com/en-us/library/ee691831(office.14).aspx

Charles Williams
Decision Models