?
Solved

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

Posted on 2008-01-30
11
Medium Priority
?
760 Views
Last Modified: 2013-12-17
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
0
Comment
Question by:cctanaka
  • 6
  • 4
10 Comments
 
LVL 10

Expert Comment

by:Smart_Man
ID: 20784912
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
 
LVL 1

Author Comment

by:cctanaka
ID: 20805110
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
 
LVL 1

Author Comment

by:cctanaka
ID: 20893523
Does anybody have any suggestions?
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
LVL 10

Expert Comment

by:Smart_Man
ID: 21134385
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
 
LVL 10

Expert Comment

by:Smart_Man
ID: 21134411
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
 
LVL 1

Author Comment

by:cctanaka
ID: 21158274
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
 
LVL 1

Author Comment

by:cctanaka
ID: 21167372
Dear NetMinder,

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

cctanaka
0
 
LVL 10

Expert Comment

by:Smart_Man
ID: 21168961
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
 
LVL 1

Author Comment

by:cctanaka
ID: 21190316
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
 
LVL 1

Accepted Solution

by:
cctanaka earned 0 total points
ID: 21578829
After I have waited a long period for an answer I decided to close this questions. Thanks anyway.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question