I am using excel sheet with SAS addin 7.1 . I want to refresh all the data including data sets and pivot tables of the workbook with a macro. I also tried the following macro but the error is "compile error: user-defined type not defined" in the highlighted line Private Sub Workbook_Open() Application.COMAddIns.Item("SAS.ExcelAddIn").Connect = True Dim SAS As SASExcelAddIn Set SAS = Application.COMAddIns.Item("SAS.ExcelAddIn").Object SAS.Refresh (SheetName) end sub() Note: the declaration of SASexcel addin is the place where the problem persists everytime Thanks Varun A
... View more