Excel Version Control!!

[kuldeps]

Hi Guys ,

Just wondering what is the best way for version controlling Excel ? Getting lots of version conflicts...

Will it be good idea to version control each and every modules or entire excel sheet.

Any ideas, pointers would be really great help.

Regards,

 

[Gruuuu]

Here's a pretty common one.

If Application.Version = "12.0" Then
Workbooks(workingbook).SaveAs Filename:=filesavename, FileFormat:=56
Else:  Workbooks(workingbook).SaveAs filesavename
End If

This is for saving in 2003 format. If you're in 2007, the file has to be downgraded, if not, saving to native format is ok.

 

[SkipVought]

Are you referring to Excel Application versions, or are you referring to your personal coding version control?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kuldeps]

Hi Gruuuu ,
Thanks for the response!! Sorry I was not clear in my question?

I am not refering to Excel Version.. I am refering to Coding version control...

VSS , CVS, etc...

Hi Skip : Hope I have clarified your quetion.

Regards,

 

[SkipVought]

Please clarify your jargon: VSS, CVS

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kuldeps]

OK...

VSS : Visual Sourse Safe.. Come with MS Visual Studios installation.. I have used this for source controlling Visual Basic apps...

CVS : The Concurrent Versions System (CVS), also known as the Concurrent Versioning System, is a free software revision control system in the field of software development. Version control system software keeps track of all work and all changes in a set of files, and allows several developers (potentially widely separated in space and/or time) to collaborate.

 

[SkipVought]

So do you have that kind of environment? If you have many disbursed developers, I suppose that this would be a necessary tool.

What is your current strategy for rolling out versions?

What is the volumn/frequency of changes?

What is the number of affacted users?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}