Sas add-in for office 8.3 - "Reset" method

GiorgioDonelli — Tue, 24 Oct 2023 14:39:36 GMT

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

Re: Sas add-in for office 8.3 - "Reset" method

KatS_SAS — Thu, 09 Nov 2023 20:55:26 GMT

Hello Giorgio,

In using Visual Basic coding with the SAS Add-in, we do not have the ability to "reset" the report in Visual Basic coding. You will have to select it manually.

Let me know if you have any additional questions regarding this issue.

topic Sas add-in for office 8.3 - "Reset" method in SAS Programming

Sas add-in for office 8.3 - "Reset" method

Re: Sas add-in for office 8.3 - "Reset" method