ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add ins vs. Templates (https://www.excelbanter.com/excel-programming/412019-add-ins-vs-templates.html)

Harry

Add ins vs. Templates
 
I have a user who writes VBA code in Templates.
I am trying to convince him to use add-ins instead.

Are there any advantages to using templates (xlt) versus the add-in (xla)
format?

thanks

eliano[_2_]

Add ins vs. Templates
 
Hi Harry.
Probably i have not understood; however try to use a Template
with his own Vba code and a Templates vith no Vba code,
without instal the add-ins.
Regards
Eliano




On 4 Giu, 03:50, Harry wrote:
I have a user who writes VBA code in Templates.
I am trying to convince him to use add-ins instead.

Are there any advantages to using templates (xlt) versus the add-in (xla)
format?

thanks



Bob Phillips

Add ins vs. Templates
 
From a design paradigm, I see templates as part of the user interface, and
so if they have any code, it should only be code required for data input
validation or presentation. It should not be the business logic, that should
be in a separate layer, be it addins, or a VB/.Net process.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Harry" wrote in message
...
I have a user who writes VBA code in Templates.
I am trying to convince him to use add-ins instead.

Are there any advantages to using templates (xlt) versus the add-in (xla)
format?

thanks





All times are GMT +1. The time now is 03:00 AM.

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