I am trying to trigger (run) a SAS stored process from Excel using SAS Excel ADDIn using VBA code. I am able to trigger Stored Process and get output in Excel. But when I am passing prompt values via VBA it is giving a "Run-time Error 429" as mentioned in the attached file. Please find my code below -
Application.DisplayStatusBar = True Application.StatusBar = "Please Wait. Connecting SAS EG..."
Dim sas As SASExcelAddIn Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
Dim rngRange As Range Set rngRange = Range(Cells(5, 1), Cells(Rows.Count, 1)).EntireRow rngRange.ClearContents
Dim a1 As Range Set a1 = Sheet1.Range("A5")
Dim prompts As SASPrompts Set prompts = New SASPrompts prompts.Add "dpt_nm", "Living"
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.