Actually I ab building a model in Excel where I want SAS to perform its function in the backend. So the process will be fully automatic, running through VBA macros and the user doesn't have to click SAS add - in. But the only problem lies there is I have prompt of multiple values and I am not able to figure out how can I pass multiple values to SAS prompts. I am using this code Dim sas As SASExcelAddIn
Set sas = Application.COMAddIns.Item("Sas.ExcelAddIn").Object
Dim prompts As SASPrompts
Set prompts = New SASPrompts
prompts.Add "RF_SEL1", Range("H2:H5").Value
Dim rng As Range
Set rng = Worksheets(1).Range("A1")
sas.InsertStoredProcess "/User Folders/SAS Guest/My Folder/Stored Process for Program 2", rng, prompts But this code is not woring with the RANGE("H2:H5"). How can I provide it with the range of values.
... View more