Build Add-in in C++

  • Thread starter Thread starter Bura Tino
  • Start date Start date
B

Bura Tino

Hi,

This is most defintely an FAQ, but I'm asking it here because there
seem to be several answers to this question.

I need to write functions in C++ and make them available in Excel
(Excel2002) as wooksheet functions. I already have an elaborate system
written in C++ (albeit in Unix) and I want to use Excel to interface
it.

What is the current recommended solution and what are the necessary
tools for it?

Many thanks in advance.

Bura
 
Hi Bura,

For Excel 2002 you've got two choices: XLLs or Automation Add-ins. The
main difference between the two is that Automation add-ins require COM
programming skills, while XLLs don't. Both require a pretty intimate
knowledge of Excel. For more information on XLLs, see the Excel 97 SDK (for
the purposes of XLL programming, everything's still the same):

http://msdn.microsoft.com/library/

under:

Office Solutions Development
Microsoft Office
Microsoft Office 97
Product Documentation
Excel
Microsoft Excel 97 Developer's Kit

The files that go with it can be found at (watch the wrap):

http://download.microsoft.com/download/excel97win/Install/1.0/W9XNT4XP/EN-US/excel97sdk.exe

For Automation Add-ins, a good place to start would be here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q291392

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Thank you for recommendations. I think I will go with the COM+ solution. But
I can't seem to get started! Is there a sample which does something trivial,
like create a function that adds two numbers, and makes that function
available for use in Excel? I know C++ well, but only in unix. I don't know
anything about COM objects, .NET, etc.

Maybe one of you gurus can supply an example like that. It would be very
useful for many people...

Many thanks in advance,

Bura
 
Back
Top