Compiled Excel macros

[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.

[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)


"Tomasz Klim" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

[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.

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.


Użytkownik "Bob Phillips" <[email protected]> napisał w
wiadomości news:[email protected]...
> 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)
>
>
> "Tomasz Klim" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >
> >
>
>

[Bob Phillips]

Tomasz,

You can manipulate an Excel spreadsheet easily from a COM add-in.

Read up here


http://support.microsoft.com/?kbid=238228
How to build an Office 2000 COM add-in in Visual Basic

http://support.microsoft.com/?kbid=285337
How To Create a Visual Basic Automation Add-in for Excel Worksheet Functions

--

HTH

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


"Tomasz Klim" <[email protected]> wrote in message
news:[email protected]...
> > 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.
>
> 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.
>
>
> Użytkownik "Bob Phillips" <[email protected]> napisał w
> wiadomości news:[email protected]...
> > 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)
> >
> >
> > "Tomasz Klim" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> > >
> > >
> >
> >
>
>

[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.


Użytkownik "Bob Phillips" <[email protected]> napisał w
wiadomości news:[email protected]...
> Tomasz,
>
> You can manipulate an Excel spreadsheet easily from a COM add-in.
>
> Read up here
>
>
> http://support.microsoft.com/?kbid=238228
> How to build an Office 2000 COM add-in in Visual Basic
>
> http://support.microsoft.com/?kbid=285337
> How To Create a Visual Basic Automation Add-in for Excel Worksheet
Functions
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Tomasz Klim" <[email protected]> wrote in message
> news:[email protected]...
> > > 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.
> >
> > 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.
> >
> >
> > Użytkownik "Bob Phillips" <[email protected]> napisał w
> > wiadomości news:[email protected]...
> > > 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)
> > >
> > >
> > > "Tomasz Klim" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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.
> > > >
> > > >
> > >
> > >
> >
> >
>
>