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

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 <Ha...@discussions.microsoft.com> 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

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" <(E-Mail Removed)> wrote in message
news:96A61273-FD15-4748-8C9C-(E-Mail Removed)...
>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