UDF's via Automation Addin in Excel 2010?

  • Thread starter Ralf Steinstraesser
  • Start date
R

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top