Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

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!
0
hindersaliva
Asked:
hindersaliva
  • 2
  • 2
1 Solution
 
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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now