HI all, in SAS Visual Analytics, normally I create several reports saving it in my company's sas folders. Data inside reports can be updated daily, weekly and so on. Through add-in, I can carry sas data into Excel. First time I have to "install" VA report in excel through "Reports" button on SAS menu. The issue is that next times (e.g. the day after), the "refresh" button proposes again old data. To get new data I'm forced to click on "reset" option in the drop-down list that appears by clicking on the three-dots menu of the SAS Panel: Trying to do the same in VBA, according to this article , the "Refresh" method causes the same behaviour, I get again old data. My question is: There is a way in VBA to "reset" data so that the new data can arrive in excel? This is the code I use: Sub AggiornaSasAddIn(ObjName As String) Dim sas As SASExcelAddIn
Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
sas.Refresh ObjName
Set sas = Nothing End Sub Thanks to all in advance
... View more