After creating a connection to the workspace server, the DataService property on the workspace object will allow you to list, assign, deassign libraries, etc. Once you have a Libref object you can list data sets in that library and open a data set. To start, look at the DataService object in the help file C:\Program Files\SAS\Shared Files\Integration Technologies\sas.chm and in the ObjectBrowser in the VBA editor.
... View more