How to transform an Excel VBA Application in a selling product?

Hi,

I would like to receive some orientations about developing a system to distribute (sell) to clients, using some kind a

mechanism to prevent ilegal copies. I think about using a hard copy protection like a USB pen drive, because there will be

only a few copies.

Nowadays the system is a Excel workbook with VBA code and forms, plus OWC 11 sheets (placed inside forms).

How are the simplest, fastest and secure (against copies and reading VBA code) ways to achieve a selling product? (Visual

Basic, Visual Basic with VSTO, Visual Basic calling OWC 11, etc)

Thanks in advance,
Cesar
LVL 1
cctanakaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Smart_ManCommented:
for protecting your code you can have password protection on your excel file. for protection against illegal copying simply you can hard-wire a protection method. withing your code. like getting the computer name in your application and save it somewhere in your file. and ask for a key that depends on that computer name/hard disk serial . that key code be generated by an equation you the only one have. so users have to email you with generated code then you post back the unlock code that only works for their pc. or whatever ideas you have , that enables you to have a demo copy for all and a full copy for authenticated users.

there are more professional methods. but i understood that you are going to sell only few copies.

waiting for your reply so we can go forward
0
cctanakaAuthor Commented:
Hello Smart_Man,

Protecting the code with a password is too vulnerable, isn't it? There are several utilities that changes the password.
The second part - protect against illegal copies - would be great if the first one was not vulnerable, because if one break the code protection could change code for the second part.
Is there a stronger protection for the code?
0
cctanakaAuthor Commented:
Does anybody have any suggestions?
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Smart_ManCommented:
sorry for not responding , i usually get back to the subject by getting the email that tells me there is a new post. if you still interested in finding protections..

would you care to try a .net , vb application that have the excel linked inside it. so it is easier to protect the program ?

if you are not interested please let me know so i do not post here again
0
Smart_ManCommented:
you can also try some extra security using

Workbook Open Event
WorkSheetChange Event

ummmm . but i wont go for excel only if i am to produce a product with anti-copy protection and something to protect my code too.
0
cctanakaAuthor Commented:
Smart Man,

What about a .net vb app, how can I call an Excel workbook linked to it, protecting the system? Is there any simple example?
0
cctanakaAuthor Commented:
Dear NetMinder,

I have received more comments from SmartMan. Please desconsider the prior request of cancellation.

cctanaka
0
Smart_ManCommented:
dear author , please feel free to give points ONLY when you want to give them.

I hope you found your answer here and that is why you are giving points.
0
cctanakaAuthor Commented:
OK SmartMan.

Would you suggest a start point abou a .net app calling an Excel spreadsheet, as you told before? How can I do that? Is there any material to research?
0
cctanakaAuthor Commented:
After I have waited a long period for an answer I decided to close this questions. Thanks anyway.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.