When I open up Excel and connect to a SAS server through AMO, a WORK library is created. Is there any way for a stored process that is executing during that AMO session to determine the file path to where the AMO WORK library is?
Thanks, but no. The WORK library in AMO is different from the WORK library that gets created when the STP runs. I was just wondering if there was any way that the STP that is called could be aware of where the WORK directory is that exists in AMO.
What I'm looking for is a way to have two stored processes talk to each other when they're run through the same AMO session so that I can have multiple stored processes output to multiple worksheets in the same workbook.