Advice: Security of VBA project

This might be of use though not completely finished:

http://www.thecodenet.com/articles.php?id=38

:)

Nice Mark!

Now I don't need to make a write up about it myself - just point to Your article ;)

Don?t forget to mention the pros & cons about the different Instancing :)

Kind regards,
Dennis

Thanks for the link. I suppose I should create a COM addin eventually at least once.

Thanks Dennis!

:)

Hi Mark,

Thanks for that! It's a cool site you have there!

Question on the COM add-in... you need a full copy of VB6 or Visual Studio to do it? Although I've studied some VB6 procedures for VBA use on occasion, I've never programmed in VB6 (yet) so am not fully aware of what software is required.

Thanks,

Cheers Ken.

Yep to create a COM addin you need a copy of VB6. There is very little difference between VBA and VB6 so getting into it is easy. The main difference is the Forms where there are more controls and options available. There are other things that are useful though like the Printer object, Drawing methods and Control arrays.

:)

Yeah...if you have any questions on VB6, just ask me! (NOT!!)

You should be able to do it with VBA - what you need is the ability to compile to a DLL, which MS Office Developer, if you have it, gives you. I should add that I have not done this!!!

Hi guys,

No, it's not possible to create with the MOD version :(

It require a public class which is not possible to create with the MOD so the only way is to get Your hands of a copy of MS VB 6.0 and if You're lucky You may get it for a good price via some public auction-site like E-bay.

I believe the above is a good explanation why MOD was never a cash-cow for MS.

( The latest version is associated with Visual Studio.NET and it's named to VSTO, Visual Studio Tools for Office).

Kind regards,
Dennis

Thanks for that Dennis. I have seen various references to using MOD but had never tried it. Shame really, because to my little mind it seems you ought to be able to use VBA.

Quote:

---

I believe the above is a good explanation why MOD was never a cash-cow for MS.

---

That and the fact that if you're going to shell out for it why not get VB6 anyway and have increased functionality!

:)

Quote:

---

Originally Posted by XL-Dennis

Hi guys,

No, it's not possible to create with the MOD version :(

It require a public class which is not possible to create with the MOD so the only way is to get Your hands of a copy of MS VB 6.0 and if You're lucky You may get it for a good price via some public auction-site like E-bay.

I believe the above is a good explanation why MOD was never a cash-cow for MS.

( The latest version is associated with Visual Studio.NET and it's named to VSTO, Visual Studio Tools for Office).

Kind regards,
Dennis

---

Hi Dennis, long time no speak...

Are you sure you can't create a COM add-in using Office XP Developer edition? Although in the past I've usually used VB6 to create COM add-ins, I have created at least one using 'Developer. For example, the attached (useless) DLL file was created using Excel XP Developer. I'm confused by your reply as I can't think of any other worthwhile use for 'Developer other than creating COM addins. Am I missing something? :dunno

I've also attached the VBA project file which contains the source code.

Kind regards,
Dan

Hi Dan :)

Quote:

---

Are you sure you can't create a COM add-in using Office XP Developer edition?

---

You?re right that my previous answer should be refined and I apologize for being unclear:

Automation add-ins
Creating userdefined worksheetsfunctions can't be done with MOD as it miss the option Public - Creatable for classes.

COM add-ins
MOD can create com add-ins which extend the interface of Excel.

Quote:

---

Am I missing something?

---

I believe that with Your post and this one we don't miss anything ;)

Thanks my find for clarifying it and for pointing it out :)

Dennis