Your SAS programs, embedded in web apps and elsewhere

Executing a Stored Process from Excel

Reply
N/A
Posts: 1

Executing a Stored Process from Excel

We have a user who created a simple Stored Process. He can execute it from Excel, but I cannot. I see the following. Does anyone know what thie means? Thanks!

"Unable to execute the stored process "ASUV_SP". Please report this error to your site administrator."


System.Runtime.InteropServices.COMException (0x80041001): Transaction open failed.Physical file does not exist, C:\Documents and Settings\dbisbik\My Documents\My SAS Files\9.1.
at SASStoredProcessService.ExecutionClass.WaitForCompletion(Int32 waitMilliSeconds)
at SAS.OfficeAddin.StoredProcess._ExecuteInternal(String& errorMessage)
SAS Super FREQ
Posts: 304

Re: Executing a Stored Process from Excel

Karen-

Could you please repost this question in the "Integration with Microsoft® Office" forum? Someone there will be better suited to answering your question. The link is:

http://support.sas.com/forums/forum.jspa?forumID=7&start=0

Another, perhaps better option, is to open a track with our Technical Support department:

http://support.sas.com/techsup/contact/submit_emits2.html

One quick thought that I have is perhaps you do not have operating system permission to access the directory "C:\Documents and Settings\dbisbik\My Documents\My SAS Files\9.1".

Best regards,

Vince DelGobbo
SAS R&D
Ask a Question
Discussion stats
  • 1 reply
  • 194 views
  • 0 likes
  • 2 in conversation