Compiled Excel macros

T

Tomasz Klim

Hi,

I think about selling my own Excel wordbook, that contains some macros. But
I don't want anyone to see these macros.

I tried to set password on VBA project, but it's insecure. There are
programs to crack this password.

I know, that Access has *.mde files, which contain macros in a compiled
form.

Does Excel have a similar functionality?

Are there any other hints to prevent users from seeing the macros?

Thanks in advance!

T.
 
B

Bob Phillips

You can create COM addins or DLLs that are written in VB and can be
compiled, but not in VBA. Problem here of course is that you need a full
version of VB.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
T

Tomasz Klim

You can create COM addins or DLLs that are written in VB and can be
compiled, but not in VBA. Problem here of course is that you need a full
version of VB.
Click to expand...

That's not a problem - I got it.

I thought about creating COM addin, but the real problem is that these
macros
are very spreadsheet-specific: importing and exporting from raw spreadsheets
to database, re-creating series in charts, sending e-mails using another COM
component, and downloading some files. Nothing more...

Besides, I still don't know, how to create COM addin...

T.
 
T

Tomasz Klim

Hmm, is there any manual, how to create "generic" COM component in VS 6.0 ?

Anyway, I have some ideas now. Thanks!

T.
 
Top