Excel Automation Add-in

F

Fredrik Wahlgren

Hi

I'm trying to create a simple Automation add-in for Excel using ATL and and
C++. I want to create something like this:
http://www.thecodeproject.com/dotnet/excelnetauto.asp?df=100&forumid=78701&exp=0

However, I want to use ATL and C++. Unfortunately, Excel doesn't recognize
the add-in. I get an error message saying that Excel didn't find an
automation server or that I don't have the proper rights. Unfortunately,
this message is in Swedish.

I think it has to do with some registry settings that are missing. It seems
as if I need to add something to the rgs file but I don't know what changes
I need to do. I use VS 2003 .NET

Any ideas?

/Fredrik
 
F

Fredrik Wahlgren

I think I know what the problem is. this is what I found:
" If you want to use your automation add-in as an automation add-in, you
need to load it via the Automation Add-ins dialog. For it to appear in this
dialog, you need to add a couple of additional registry entries.
Specifically, you need to create an additional subkey of HKCR\CLSID, with
the GUID of your add-in's primary class, delimited with braces. As a child
of this GUID key, you need to create a final key named Programmable. This
needs no value."

How can I edit the rgs file so that I get these entries?

/Fredrik
 

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