I'm trying to establish a connection to the SAS Server and create a workspace using VBA. However, I'm having a problem trying to figure out how to browse the libraries and access datasets on the server from Excel. Is there a call for the Add-In dialog in VBA that would allow me to access the libraries?
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.