I have been told to move my vba excel code to a DLL so it is more secure and
the code is external to the .xls file itself. I have been searching for a
quite a while on how to do this. Any suggestions?

Hi Mike,
if you will use Visual Studio Tools For Office to create the DLL I can
tell you that is more secure than Excel file with VBA but...
It's not secure on 100% as it uses Framework and IL code... that
means someone can get your source code. If you want to avoid this you
have to use Obfuscator (see Google).
Furthermore if you use VSTO you need Framework installed on pc and al
least Office 2003.

Bye Denis



Mike H. ha scritto:

> I have been told to move my vba excel code to a DLL so it is more secure and
> the code is external to the .xls file itself. I have been searching for a
> quite a while on how to do this. Any suggestions?

First you need VB6 or VB.Net. Do you have either?

--
---
HTH

Bob

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



"Mike H." <(E-Mail Removed)> wrote in message
news:B6E1FB30-82E1-4EAD-8FD9-(E-Mail Removed)...
>I have been told to move my vba excel code to a DLL so it is more secure
>and
> the code is external to the .xls file itself. I have been searching for a
> quite a while on how to do this. Any suggestions?