Get list of all Sourcesafe files and version? easy way?

I need to get a list of all the files in Visual Source safe aswell as their versions.  I know I can get the versions if I right-click and select Properties but want to know if there is an easy way to print the files along with their versions as there are hundreds of them.
I have a list of what's currently in Production (stored in a database seperate to VSS).  This lists the file name aswell as the version.  I need to do a comparison against what's in VSS, so I need to generate the same type of list.
Can anyone please point me in the right direction? I have no idea whether this is actually possible ?!?!  Maybe I could use a script?
Thanks :-)
ciara_barry123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RobSampsonCommented:
Ciara,
You can use the GetFileVersion method of the File System Object like this:
'=========================
If objFSO.FileExists("C:\Program Files\Citrix\icaweb32\wfica.ocx") = True Then
      strFileVersion = objFSO.GetFileVersion("C:\Program Files\Citrix\icaweb32\wfica.ocx")
Else
      'MsgBox "File cannot be found."
End If
'=========================

If you combine this with a routine that gives you all of the files in a folder, you can loop through them.

Regards,

Rob.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Version Control

From novice to tech pro — start learning today.