@Scott_Mitchell
Try this sample VBA code (modify for your stored process):
Sub InsertStoredProcess()
Dim sas As SASExcelAddIn
Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
sas.Options.AutoInsertResultsIntoDocument = True
Application.DisplayAlerts = False
Dim stp As SASStoredProcess
Set stp = sas.InsertStoredProcess("/Shared Data/Stored Processes/Bar chart prdsale", Sheet1.Range("A1"))
Application.DisplayAlerts = True
End Sub
Unfortunately, I do not think there is a way to suppress the new SAS Panel on the right, but I am checking with R&D to be certain.