Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Excel VBA - distribute secure solution

Hi

I want to distribute an Excel 2010 VBA solution to an IT company. I don't want
them to be able to view my VBA code - are there any products out there that can be used to easily do this.

Thanks
0
Murray Brown
Asked:
Murray Brown
  • 6
  • 4
  • 3
  • +2
2 Solutions
 
SiddharthRoutCommented:
Yes. You have 2 options

1) Create an Excel AddIn
2) Use Vb.Net to create a COM DLL file.

Sid
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Not sure if this still applies in 2010, but could you not secure your VBA project with a password??
0
 
SiddharthRoutCommented:
>>>Not sure if this still applies in 2010, but could you not secure your VBA project with a password??

Yes, it does apply but VBA passwords are easy to Hack :)

Sid
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I'm a believer :)
0
 
SiddharthRoutCommented:
So Am I teylyn So Am I :)

Sid
0
 
Kalpesh ChhatralaSoftware ConsultantCommented:
you can create addin for excel 2010

check below link
http://msdn.microsoft.com/en-us/library/cc668205.aspx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Sid, shall we hold hands and dance around a lamp post doing "Singing in the rain"?
0
 
SiddharthRoutCommented:
That happens only in Indian Cinemas. I like the opening scene though :|

Sid
0
 
philip m o'brienCommented:
I think you should.

Back on subject this is the age old question of protecting code in VBA, a relatively pointless exercise if trying to protect from the dishonest, but simple password protection should suffice to deter someone who doesn't care much anyway. So yes, go with Teylyn's suggestion of password protection on the VBA and lock for viewing.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Sid, next time I'm in India, you'll have the honor to arrange a lady's night out for your wife, her 6 to 12 best friends, and me to go see a super-mega-heart-wrenching chick flick Bollywood movie. Make sure to arrange for some tasty nibbles to keep us interested during the interval and the dull scenes.

(Does that not sound miles better than "eat my shorts"??) :)
0
 
SiddharthRoutCommented:
>>>(Does that not sound miles better than "eat my shorts"??) :)

Any Day! Arf Arf Arf...

You are most welcome :)

@murbro: Sorry for 'hijacking' your thread :)

Sid
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. No problem. Made the conversation a little more interesting :)

The reason I mentioned that I am giving this to an IT company is that they will definitely hack it.
I have time constraints so building an add-in might be tricky
What about the whole digital certificate  thing - is that not worthwhile.
My client is prepared to pay the one or two hundred dollars.
Need a fast secure approach.
Thanks
0
 
SiddharthRoutCommented:
>>>The reason I mentioned that I am giving this to an IT company is that they will definitely hack it.

Then follow my 2nd Suggestion :) But it is time consuming.

OR

If you want a fast approach then hire a Freelancer to do the coding for you in VB.Net to make the dll as I suggested in post 1.

Sid
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. What about doing an Excel Workbook project in Visual Studio Tools for Office. You take the existing Workbook with its VBA and deploy that. Is this secure as is, ie can it be reverse engineered or should I add some further code protection.
0
 
philip m o'brienCommented:
that would work well, since it's compiled. Nice and secure for you, they would have to work from first principles i.e. take your ideas and create from scratch.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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