Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 6
Default VBA Coding Trick

Hi,

I want to know if there is any trick or tip to make my code looks complicated or hard to understand or a way to re-write or add to the code more lines so no one can take my work. My manager wants me to keep the code open and show it to my colleagues. Although, we don’t work in programming we are in a totally different field. Anyway, long story short I need to make the code complicated “just looking hard to read” until I finish the program so no one steal my Idea.

Thanx
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 259
Default VBA Coding Trick

On 11/07/2012 8:01 PM, sam99 wrote:
Hi,

I want to know if there is any trick or tip to make my code looks
complicated or hard to understand or a way to re-write or add to the
code more lines so no one can take my work. My manager wants me to keep
the code open and show it to my colleagues. Although, we don’t work in
programming we are in a totally different field. Anyway, long story
short I need to make the code complicated “just looking hard to read”
until I finish the program so no one steal my Idea.

Thanx




Hi

Well, for those in your company who have no idea of workbook protection
and how to easily crack it you could try that, conversely any good
knowledgeable programmer will have it cracked within a couple of minutes
using a 3rd party hack program ( like the one I use on files that have
been created by others long gone from the company ) which need some
tweaking and T.L.C.

I would be careful of what you are doing though, you may want to go back
to your employment contract/agreement and see if there is a clause
pertaining to intellectual property whilst in their employ.

Many companies write it in to protect themselves and to ensure anything
that is created on their paying time belongs to them, regardless. My
contract has such a clause and I work for a transport company, not a
blue-chip investment or programming development organization.

Any good programmer regardless of the field, will/should be able to read
through code to ascertain it's function and in all likelihood, shorten
it to his/her level if they're in the Guru category.

HTH
Mick.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 84
Default VBA Coding Trick

The term you are probably looking for is obfuscate or obfuscation. Try
searching together with VBA and perhaps Excel.

In essence, replace all variable names with meaningless characters. You can
do it manually though there are addins out there which purport to do it all
automatically.

Regards,
Peter T

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default VBA Coding Trick

A good option is to get VB6 and move code to a VB6 activeX dll.
Coding is very similar to VBA and nobody can see your code.
Still should be available on things like eBay.

RBS


"sam99" wrote in message
...

Hi,

I want to know if there is any trick or tip to make my code looks
complicated or hard to understand or a way to re-write or add to the
code more lines so no one can take my work. My manager wants me to keep
the code open and show it to my colleagues. Although, we don't work in
programming we are in a totally different field. Anyway, long story
short I need to make the code complicated "just looking hard to read"
until I finish the program so no one steal my Idea.

Thanx




--
sam99


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 538
Default VBA Coding Trick

sam99 wrote:

I want to know if there is any trick or tip to make my code looks
complicated or hard to understand or a way to re-write or add to the
code more lines so no one can take my work. My manager wants me to keep
the code open and show it to my colleagues. Although, we don’t work in
programming we are in a totally different field. Anyway, long story
short I need to make the code complicated “just looking hard to read”
until I finish the program so no one steal my Idea.


Switch to a different language, one that none of them knows and would never
understand. Malebolge or Befunge or Brainf*ck or...

--
- That's your problem.
- Actually it's not.


  #6   Report Post  
Junior Member
 
Posts: 6
Default

Thanx everyone these Ideas are really helpful
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
That did the trick Cindy Nealon Excel Discussion (Misc queries) 0 February 23rd 10 04:06 PM
Neat Trick Frank Pytel Excel Discussion (Misc queries) 4 April 21st 08 09:20 PM
Ok what's the trick to do this? Net Doe Excel Programming 1 January 19th 08 04:20 AM
Sharing a neat trick MartinW Excel Discussion (Misc queries) 6 July 9th 07 12:52 AM
Another avoid the loop trick request - on fast fill (Maybe an Alan trick) [email protected] Excel Programming 2 October 6th 04 07:13 PM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"