Solved: VSS Source Code Control for Word VBA Code

[rruckus]

Does anyone know how I can setup Microsoft Visual Source Safe (I use version 6.0) to work with Word 2007/2010 VBA code so I can checkout each module, form, and class separately?

I thought there used to be a plugin or program that let you do that?

[fumei]

Did you try google for this? Here is a starting point.

http://msdn.microsoft.com/en-us/library/aa164419(v=office.10).aspx

[rruckus]

Yah I found that - but where's the download? It says to use the "VBA Source Code Control add-in" where do I get it?

It appears to be part of "Microsoft Office 2000 Developer" but like I said, I need VSS support with Office 2007 or 2010.

[fumei]

Ah. I am assuming you have VSS, so check to see if you have the addin.

"HKEY_CURRENT_USER\Software\Microsoft\Visual Basic\6.0\Addins".

Unfortunately, I too have looked, and I can not find a source for the addin itself. I can not even find its actually name, which would help a lot.

[rruckus]

I do have VSS, but I don't have anything listed under that reg key. I don't even have the Addins folder in the registry.

Frustrating. I know it's called "VBA Source Code Control" in Office 2000 Developer but it doesn't exist in Office 2007, unless its under a different name.

[fumei]

"I know it's called "VBA Source Code Control" in Office 2000 Developer "

Do you know its dll name?

[fumei]

I found a site with a number of addins (but not free).

http://www.topshareware.com/downloads.aspx?q=vba-source-safe-add-in&p=1

However, none appear to be what you are asking about.

"code so I can checkout each module, form, and class separately?"

Could you elaborate on this? What do you mean exactly?

[rruckus]

I found an old copy of Office 2000 Developer, installed that (without installing Office 2000) and it works!

The result is that I am able to have each macro (form, module, class module, etc) as their own objects in VSS as opposed to the entire VBA template that contains all of my macros.

[fumei]

Ah. Glad it worked out for you.

[brahmin]

Hey rruckus,
Where did you find the old Office 2000 Developer installer?
Can you post a link to where you found it?

Also, which OS are you working on? Did you have to do any problems setting it up to work?

[rruckus]

I found a copy on my companies servers so I can't help you out for the download, but it must be somewhere online. Maybe here? http://download.cnet.com/Microsoft-Office-2000-Developer/3000-2018_4-15301.html

I got it to work on Windows 7 Office 2010. The only trick was when it said you needed to have Office 2000 installed, I skipped the warnings and it worked.