Source Control for Project VBA

[Adrian Miller]

Hi,

is there any way to use a source code control system with Project VBA?
Ideally with TFS?

Thanks for any advice
Adrian

 

[Rod Gill]

With VBA, usually all the code resides in one file. So, even if I have a
macro that is to be stored in the Enterprise Global, I would develop in a
standalone project then copy once tested. I would use version control on the
..mpp file or save in a document management system.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,

is there any way to use a source code control system with Project VBA?
Ideally with TFS?

Thanks for any advice
Adrian

--
Adrian Miller


__________ Information from ESET Smart Security, version of virus
signature database 4574 (20091104) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4574 (20091104) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gary Chefetz]

Adrian:

If all you are doing is writing VBA code and you're not developing large
managed code applications, using TFS is akin to swatting flies with a sledge
hammer, particularly if you're paying for TFS. There's no reason why you
can't do it, but I'd look at a more economical and easier to use option like
Subversion.

 

[Adrian Miller]

Gary,

thanks for your advice. I'm developing my .NET project against TFS, so I
would love to this for VBA, too.

Is there support for the VBA IDE for subversion? I did not find any? Nor for
TFS.

Thanks again
Adrian.

 

[Gary Chefetz]

Adrian:

As far as I know everything out there targets managed code solutions. But, I
don't see why you can't simply use any of them as an object store. Like Rod
suggested, you're probably just as well served using a SharePoint library
with automatic version control turned on.