L
Luis Simões
Hi,
I have an automation dll for the functions in excel and a VSTO dll to
control de events, commandbars and some more specific options like
adding/removing connections to databases( connection strings - simulate MS
Query for pivot tables) (My first tought and try was to use the formulas in
the VSTO but since it doesnt work i have separated the classes into
automation and vsto)
Now i have a problem...
Since one of the VSTO options is to setup some connections strings and open
a connection with that conn string, i wanted to use that already opened
connection in the functions at the automation addin. Something like
"function1(arg1)" will use the already open connection and return a value
from the database corresponding to arg1.
The problem is that the automation addin dont know the open connection and i
can't seem to find a way to specify it.
This is a little bit confusing but i hope you guys can manage
This is really important for me.
Best Regards,
Luis Simões
I have an automation dll for the functions in excel and a VSTO dll to
control de events, commandbars and some more specific options like
adding/removing connections to databases( connection strings - simulate MS
Query for pivot tables) (My first tought and try was to use the formulas in
the VSTO but since it doesnt work i have separated the classes into
automation and vsto)
Now i have a problem...
Since one of the VSTO options is to setup some connections strings and open
a connection with that conn string, i wanted to use that already opened
connection in the functions at the automation addin. Something like
"function1(arg1)" will use the already open connection and return a value
from the database corresponding to arg1.
The problem is that the automation addin dont know the open connection and i
can't seem to find a way to specify it.
This is a little bit confusing but i hope you guys can manage
This is really important for me.
Best Regards,
Luis Simões