Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Source Safe communication
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of Subversion / CVS / Source Safe | Excel Programming | |||
excel, visual basic and serial communication | Excel Programming | |||
Protect - Unprotect Sheet - Visual Source Safe | Excel Discussion (Misc queries) | |||
Excel VBA Projects & Visual Source Safe; WinAPI, Code Librarian. | Excel Programming | |||
communication | Excel Programming |