UDF's via Automation Addin in Excel 2010?
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 -- Dipl.-Ing. Ralf Steinstraesser Software Architekt Bissantz & Company GmbH |
UDF's via Automation Addin in Excel 2010?
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/libr...ffice.14).aspx Charles Williams Decision Models "Ralf Steinstraesser" wrote in message ... 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 -- Dipl.-Ing. Ralf Steinstraesser Software Architekt Bissantz & Company GmbH |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com