sOURCE CODE REPOSITORY
 

How to check in and administor changes to the VBA class modules. Its all
stored in binary, so difficult to diff.

sOURCE CODE REPOSITORY
 

I'm not aware of any program that can be used (well) for source
control for VBA code. You can, of course, export modules to bas and
cls files and those can be controlled by a source control program, but
accurate version control would still rely on the appropriate version
of the module being properly imported into and exported out of a VBA
project. Both Export and Import functions are on the File menu in the
VBA editor and both operations can be automated.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 23 May 2009 14:47:00 +0100, "Gota"
wrote:

How to check in and administor changes to the VBA class modules. Its all
stored in binary, so difficult to diff.

sOURCE CODE REPOSITORY
 

Thnaks for the response. How to tore templates where to import these
modules. IS there any way of automatically importing modules in the relevant
templtaes or xla / xls files?

"Chip Pearson" wrote in message
...
I'm not aware of any program that can be used (well) for source
control for VBA code. You can, of course, export modules to bas and
cls files and those can be controlled by a source control program, but
accurate version control would still rely on the appropriate version
of the module being properly imported into and exported out of a VBA
project. Both Export and Import functions are on the File menu in the
VBA editor and both operations can be automated.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 23 May 2009 14:47:00 +0100, "Gota"
wrote:

How to check in and administor changes to the VBA class modules. Its all
stored in binary, so difficult to diff.