12-11-2014 09:47 AM
I ran an Store Process from SAS Add in and saved its out put in one sheet.
I wrote following VBA code to trigger that SP on a button click.
Dim SAS As SASExcelAddIn
Set SAS = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
SAS.Modify ("Stored process object name")
I working fine for most of the users but for some users its showing "Out of Memory" dialog box.
Its a very small process which returns a result with around 200 observations and 10 variables.
Do we have any suggestions for this?