Hiding macro code

[Bob]

Apologies if this sounds stupid but I am the Web/DB guy.

A colleague has developed a macro the creates a tabbed report. He would
like to "hide" to VBA code somehow. What is the best way t o do this? Can
he build a VB DLL and call out to it somehow?

Thanks

 

[Earl Lewis]

Bob,

Best way to do this is by creating a DLL. Microsoft calls these COM Add-ins when it comes to the office solutions. In VB6 there was a project template that you could use to get a jump start on these and it would put all the code stubs in for you that office expected for the add-in to work properly.

A little research on MSDN into your development tool of choice (VB6, C#, etc...) should get you headed in the right direction.

Another alternative is password protecting the modules but this can be cracked by the persistent snoop.

Earl
Apologies if this sounds stupid but I am the Web/DB guy.

A colleague has developed a macro the creates a tabbed report. He would
like to "hide" to VBA code somehow. What is the best way t o do this? Can
he build a VB DLL and call out to it somehow?

Thanks

 

[Bob]

Thanks Earl - I'll pass that along

Bob,

Best way to do this is by creating a DLL. Microsoft calls these COM Add-ins when it comes to the office solutions. In VB6 there was a project template that you could use to get a jump start on these and it would put all the code stubs in for you that office expected for the add-in to work properly.

A little research on MSDN into your development tool of choice (VB6, C#, etc...) should get you headed in the right direction.

Another alternative is password protecting the modules but this can be cracked by the persistent snoop.

Earl

Apologies if this sounds stupid but I am the Web/DB guy.

A colleague has developed a macro the creates a tabbed report. He would
like to "hide" to VBA code somehow. What is the best way t o do this? Can
he build a VB DLL and call out to it somehow?

Thanks