Protecting Excel VBA app with a COM AddIn

I want to protect my VBA code from piracy (so that I can safely give a demo to a prospective client).

I thought about putting some of the code in a COM AddIn, so that it can expire on a date, or even check for Activation online. I can do both these in VBA but would like an example (tut or a book ref) for

(1) converting my VBA to a COM AddIn.
(2) procedure for my client installing the Addin - is there a wizard I can create like when you install a tool for Excel that times out after 7 days, say.

Please point me in a suitable direction.

(I have VB6 if that helps but not an avid VB6 programmer. VBA yes)

If this is easier with .NET any pointers on that would be useful too. Got VS2010 (novice).


Thanks people!
hindersalivaAsked:
Who is Participating?
 
Rory ArchibaldCommented:
See Chip's article here: http://www.cpearson.com/excel/ComAddInInVB6.htm
You can also (I think) still find samples on MSDN.
0
 
hindersalivaAuthor Commented:
Oh WOW! That was so quick and straight to the point.
I shall work through that. (and thanks Chip)

Any views on a VB.NET equivalent? or is that not an easy?

Thanks
0
 
Rory ArchibaldCommented:
I can't say that I've done all that much .Net stuff, but if you're building a COM add-in, I can't see much point in using .Net
0
 
hindersalivaAuthor Commented:
Yes thanks Rory. Just curious.
I was wondering if VSTO has anything useful in that direction.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.