SAS Excel Add-In 7.1 Stored Process Prompt Issue

kmcacattack — Tue, 13 Oct 2015 14:20:36 GMT

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.

http://support.sas.com/documentation/cdl/en/whatsdiff/66129/HTML/default/viewer.htm#n01ephrd2zgp1qn1odaruqad72az.htm

Any help with calling a stored procedure with prompts through VBA SAS Add-in 7.1 would be greatly appreciated.

Thank you,

Kyle

Re: SAS Excel Add-In 7.1 Stored Process Prompt Issue

smektalski — Fri, 01 Dec 2017 09:00:26 GMT

Any solution to this issue yet?

Re: SAS Excel Add-In 7.1 Stored Process Prompt Issue

smektalski — Mon, 04 Dec 2017 08:41:52 GMT

In order to SAS Support the solution is to change:

Set Prompts1 = New SASPrompts

with

Set Prompts1 = sas.CreateSASPromptsObject

Works for me.

topic Re: SAS Excel Add-In 7.1 Stored Process Prompt Issue in Microsoft Integration with SAS

SAS Excel Add-In 7.1 Stored Process Prompt Issue

Re: SAS Excel Add-In 7.1 Stored Process Prompt Issue

Re: SAS Excel Add-In 7.1 Stored Process Prompt Issue