Unable to use even demo MyFunc in Excel 2002

Add-in Express™ Support Service
That's what is more important than anything else

Unable to use even demo MyFunc in Excel 2002
Installation configuration issues? 
Drummond John




Posts: 1
Joined: 2007-01-15
I have turbo delphi professional, Add-in Express 2007 for VCL build 383
I open the MyExcelAutomationAddin1 demonstration project.
Aside from highlighting .Value of range as undeclared, all seems ok.
I open the type library and register the project.

I get a successfully registered active x server dialog box

I open excel 2002
under tools com add ins I can see coMyExcelAutomationAddin1

Load behaviour - load at startup.

I put =MyFunc(D6) in a cell (D6 contains the value 2) and the cell displays
#NAME?

Macro security I have set at low and trust all installed add ins and templates.

I have rebooted the computer but get exactly the same behaviour.

If I open the dll with the delphi type library editor I can see the function. I've not edited the file.

What am I doing wrong?
Thank you.
Kind Regards, John.
Posted 15 Jan, 2007 15:24:53 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hi John,

I have just rebuilt and tested the sample using Turbo Delphi Pro and MS Office 2002. Works fine for me. Please check the Tools -> Add-Ins... dialog box (not COM Add-ins). Do you see your add-in there? Is it checked?


P.S. Note that we take up your forum requests in the order we receive them.
Besides, it may take us some time to investigate your issue. Please be sure we will let you know as soon as the best possible solution is found.
Posted 16 Jan, 2007 03:52:22 Top