Hi , I tried to insert the following code in macro editor Sub TestConnectionToSAS() Dim sas As SASExcelAddIn Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object sas.HelloWorld End Sub I am getting a complie error: USer-Defined type not defined. I assume this is because connection to API is not working properly. I am unable to go to references tab within macro editor to enable SAS COM add-in. Am I missing something.Please let me know . Thanks ... View more