ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Question with Excel Automation Add-in (https://www.excelbanter.com/excel-programming/386768-question-excel-automation-add.html)

Anonymous

Question with Excel Automation Add-in
 
Hi,

I have created an add-in for excel using managed code (in this case I use
VC# express edition). In my class constructor, I have a call to my .NET
remoting object, e.g.

public AddInClass() {
// connect to remote server
ServerConnectObj conn = new ServerConnectObj();
// create remote object
RemoteType rObj = new RemoteType();
}

Whenever I have this remote server connection things going on in my
constructor, my automation add-in function would not be recognized by Excel.
Meaning, I can add the add-in into excel properly. But the function does not
show up on the insert function dialog box nor I can use it in my excel. I
have the dll for RemoteType in the same folder as my Excel Add-in dll. I
don't know what's going on here. Can someone please help? Thank you!


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com