Source code repository

[Gota]

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

 

[Jay Freedman]

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

You could use the Export command to save each module in a .BAS file, which is
essentially just a text file, and store that in the repository. The Import
command will bring the code into the same or another template.

If you have userforms, each one is exported as two files: a .FRM file containing
the code, and a .FRX file containing the binary representation of the design
layout.

 

[Steve Rindsberg]

You could use the Export command to save each module in a .BAS file,

class modules would export to .CLS files instead of .BAS but carry on, everything else is teh
same:

 

[Gota]

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?

 

[Steve Rindsberg]

Thnaks for the response. How to tore templates where to import these
modules.

Can you try that again? I don't understand the question.

IS there any way of automatically importing modules in the relevant
templtaes or xla / xls files?

Google "VBA code cleaner"

There are several examples out there, source code included. These won't do
what you're after but will give you code examples of how to export and import
modules in a file.