Visual Source Safe communication ChadFo 30.09.2006 11:42:01 Question: I have an Excel VBA application that needs to communicate to Visual Source Safe. Upon researching the topic, I understand that one can do this in VBA, but dont quite understand how to go about doing this. Application does talk to both MS Access (for database communication) and MS Outlook (for emails). I'm guessing, the method is more / less the same mechanism where you create a VSS object in the communication routine .. . public sub mySub() Dim myObject as Object Dim commString as String .... commString = ".... " ' whatever you need to stuff connection info, user id / passwd, etc here ... .... myObject = CreateObject(" VSSDatabaseObject " ) ' ??? myObject.Open comString, ,,, ' (humor whatever parameters ?) .... (essentially following the same methodology one would use to communicate to other objects) ... Is this the proper approach ? ... would love to see a VBA code example ... I did find something very similar in Java that accomplishes this ... Would appreciate any help. Thanks, Chad