SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

"Out of memory" Excel VBA

Reply
Frequent Contributor
Posts: 89

"Out of memory" Excel VBA

Hi,

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?

Thanks

Ask a Question
Discussion stats
  • 0 replies
  • 311 views
  • 0 likes
  • 1 in conversation