caisersouze
New Member
- Joined
- Sep 19, 2018
- Messages
- 1
[FONT="]Hi! My customer has an XLS excel files with third part add-in for get market data and with macros with calls to a .Net dll for read and write on sql server tables. [/FONT]
[FONT="]My customer would put the XLS excel file and .net dll in a intranet web page under authorization control because only some people can use it.[/FONT]
[FONT="]The XLS for work correctly need a reference to dll, but the excel file seems to work without necessarily registering the .net dll, it even seems to work with the dll placed on a intranet shared folder.[/FONT]
[FONT="]So what is the best way for deploy both files without doing manual installations on the customer PCs?[/FONT]
[FONT="]Alternatively if we migrated the .net dll code to asmx web service, what is the best way to consume web service from macro vba excel (xls - 2003)?[/FONT]
[FONT="]Thanks in advance[/FONT]
[FONT="]My customer would put the XLS excel file and .net dll in a intranet web page under authorization control because only some people can use it.[/FONT]
[FONT="]The XLS for work correctly need a reference to dll, but the excel file seems to work without necessarily registering the .net dll, it even seems to work with the dll placed on a intranet shared folder.[/FONT]
[FONT="]So what is the best way for deploy both files without doing manual installations on the customer PCs?[/FONT]
[FONT="]Alternatively if we migrated the .net dll code to asmx web service, what is the best way to consume web service from macro vba excel (xls - 2003)?[/FONT]
[FONT="]Thanks in advance[/FONT]