Solved

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

Posted on 2007-03-26
1
208 Views
Last Modified: 2013-11-25
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 :-)
0
Comment
Question by:ciara_barry123
1 Comment
 
LVL 65

Accepted Solution

by:
RobSampson earned 500 total points
ID: 18887156
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question