Problem in Shared Add-in ( For Gurus )

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luis Simões - 18 Jan 2005 18:37 GMT

I am developing a component that i needed to receive formulas requests from
excel.

Lets suppose i have a function in a shared add-in dll using PIAs from Office
2003 and when i am using excel and insert a formula like
"=formula1(arg1,arg2) matching a formula in my add-in it will execute and
place the result in the corresponding cell.

The PIAs are working ok since i could add the commandbar and receive events
requests for beforedoubleclicks on cells, changesheet etc....

Please try to give me some lights :)

PS: Just another thing... When i try to use the SN -T filename.dll the
command line says that the dll don't have a strong name. Wasn't it suppose to
since i have built it with the VS.NET?
If not how can i make it a Strong Name and what are the diferences between a
strong or not strong name dll?

Best Regards,
Luis Simões

Reply to this Message

Fredrik Wahlgren - 19 Jan 2005 00:50 GMT

> I am developing a component that i needed to receive formulas requests from
> excel.
[quoted text clipped - 17 lines]
> Best Regards,
> Luis Sim??es

Do you want to know how to create a user defined function in your dll? You
just create a new interface and register it under Tools|add-ins. Click on
the Automation button and point at your interface. Here's a good article:
http://www.codeproject.com/dotnet/excelnetauto.asp

/Fredrik

Reply to this Message

Luis Simões - 19 Jan 2005 10:25 GMT

Hi Fredrik,
That way i already could make it...
But i wanted to incorporate the functions/formulas and also some
functionalitys relating to commandbars, menus etc....

And i have a class that implements Extensibility2 with all the relative
events...

The LoadBehavior is = 3 or in other words it loads at startup...

I tried to put the class with the Interface DualAuto but it goes crazy and
the code seems to loose the global variables... menus keep repeating and
don't close on close event.. , the functions only work if the LoadBehavior is
diferent than 3... Well its a big mess...

I managed to make it by creating a project for the functions and a project
for the commandbars and menus! That was not really my point but well till now
it solves my problem i think.

If you know how i can incorporate all in one project let me know ;)

Best Regards,
Luis Simões

> > I am developing a component that i needed to receive formulas requests
> from
[quoted text clipped - 29 lines]
>
> /Fredrik

Reply to this Message

Luis Simões - 19 Jan 2005 12:13 GMT

Damn now i remember... the solution of having a Automation Addin and a VSTO
Addin working separatly probably is not a good ideia ;/ now that i was
getting really happy i realized that the purpose of having the VSTO project
is to mainly create and activate Database Connections... Lets suppose i have
a list of database connections saved.. and i activate one of them, how can i
use that connection in the automation add-in so my formulas querys the
database connection established?

I thought about passing variables to the automation one but it wont keep
global variables and i didn't wanted to pass the connection string to the
formula for obvious reasons :)

Anyway to manage this? This is hard as hell... ehehehe

Best Regards,
Luis Simões

> Hi Fredrik,
> That way i already could make it...
[quoted text clipped - 53 lines]
> >
> > /Fredrik

Reply to this Message

Problem in Shared Add-in ( For Gurus )

Free Magazines