10-13-2015 10:16 AM - edited 10-13-2015 10:20 AM
I have recently upgrade from SAS Add-in 5.1 to 7.1. When I run my VBA code that calls a stored procedure with prompts, I get an error when defining the New SasPrompt (Run-time Error '-2148024894 (80070002)' Automation Error, The system cannot find the file specified.) The line in bold below is where the VBA code stops.
Sub MoveSASFiles() Dim sas As SASExcelAddIn Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object Dim Prompts1 As SASPrompts Set Prompts1 = New SASPrompts Prompts1.Add "StartLib", "/sas_nas_allshr/PermData/" Prompts1.Add "DatasetMove", "Summary" sas.InsertStoredProcess "/selact/Move_to_AMO", Sheet1.Range("D11"), Prompts1 End Sub
This code worked fine in 5.1. I aslo have the reference for the SAS Add-In 7.1 for Microsoft Office selected.
When looking at the updates for 7.1, it looks like the Prompts controls may have changed.
Any help with calling a stored procedure with prompts through VBA SAS Add-in 7.1 would be greatly appreciated.
12-04-2017 03:41 AM
In order to SAS Support the solution is to change:
Set Prompts1 = New SASPrompts
Set Prompts1 = sas.CreateSASPromptsObject
Works for me.