Visual Source Safe communication

C

ChadFo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top