Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compiled Excel macros
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. |
#2
|
|||
|
|||
Compiled Excel macros
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" wrote in message ... 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. |
#3
|
|||
|
|||
Compiled Excel macros
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" napisał w wiadomości ... 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" wrote in message ... 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. |
#4
|
|||
|
|||
Compiled Excel macros
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" wrote in message ... 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" napisał w wiadomości ... 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" wrote in message ... 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. |
#5
|
|||
|
|||
Compiled Excel macros
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" napisał w wiadomości ... 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" wrote in message ... 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" napisał w wiadomości ... 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Help for old macros with Excel 2002 | Excel Worksheet Functions | |||
I deleted all macros in Excel but still get dialog box | Excel Discussion (Misc queries) | |||
Are macros created in Excel 2003 compatible with Excel 5.0/95? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |