Erich Wessely
Posts: 55
Joined: 2019-01-31
|
Hello,
I'm completely new to Add-In-Exress.
I've developed an Excel Add-In with Excel.DNA which contains UDFs which can be used on the worksheet and also in VBA code in modules of the Workbook.
Because of the cool features of installation and auto-update of Add-In-Express, I want to convert my AddIn.
I don't know much about the internal storage of excel files: Would it be possible to create a new AddIn with Add-In-Express containing the same UDFs (same name, same parameters, same return values) and the existing Excel worksheet will keep working when changing the AddIn. Or may I run into troubles doing so? Will the VBA code which uses UDFs also work and use the functions from the new AddIn?
Do I have to expect any other troubles?
many thanks for help and suggestions
Erichew |
|
Andrei Smolin
Add-in Express team
Posts: 18793
Joined: 2006-05-11
|
Hello Erich,
Erich Wessely writes:
Would it be possible to create a new AddIn with Add-In-Express containing the same UDFs (same name, same parameters, same return values) and the existing Excel worksheet will keep working when changing the AddIn. Or may I run into troubles doing so?
We don't know; we don't have that experience.
Erich Wessely writes:
Will the VBA code which uses UDFs also work and use the functions from the new AddIn?
If your assembly contains a UDF only, then the VBA code will be able to work (provided that the sigature of the functions don't change).
Andrei Smolin
Add-in Express Team Leader |
|