Results 1 to 1 of 1

Thread: SAS Manage Content Refresh via Windows Task Scheduler

  1. #1

    SAS Manage Content Refresh via Windows Task Scheduler



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I am having the excel workbooks embedded with the SAS Datasets using the SAS Addin.

    Currently, I'm manually opening the Excel report which is embedded with SAS Datasets and in the menu bar

    SAS - > Manage Content -> Refresh

    It will refresh all the datasets inside the workbook.

    Am trying to automate this process using VBA and it is working fine when i was running it via Visual Basic Editor.

    But whenever i schedule this process, the VBA fails by throwing the Error message in the below line of code,

    Sub Test()
    Dim WB As Workbook
    Dim SAS As SASExcelAddIn
    Dim SName As String

    Application.ScreenUpdating = False
    ' To Refresh the SAS Datasets attached in excel
    Set SAS = ThisWorkbook.Application.COMAddIns.Item("SAS.ExcelAddIn").Object
    SAS.Refresh

    End Sub
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	sas_refresh.png 
Views:	15 
Size:	4.4 KB 
ID:	4807  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •