https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Connect-to-SAS-Server-using-VBA/m-p/45221#M697 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. Wed, 07 Jul 2010 19:00:30 GMT CaseySmith 2010-07-07T19:00:30Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Connect-to-SAS-Server-using-VBA/m-p/45220#M696 Hi,<BR /> <BR /> 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? Wed, 07 Jul 2010 18:38:24 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Connect-to-SAS-Server-using-VBA/m-p/45220#M696 Gursky 2010-07-07T18:38:24Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Connect-to-SAS-Server-using-VBA/m-p/45221#M697 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. Wed, 07 Jul 2010 19:00:30 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Connect-to-SAS-Server-using-VBA/m-p/45221#M697 CaseySmith 2010-07-07T19:00:30Z