06-08-2016 02:38 PM
I have following code which I have been running for couple months in my daily job. But since yesterday it stopped working. It opens the excel file and then it does not do anything (not running the VBA macro at all). Below is my code. Please let me know if any settings need to be changed...
Below is my code:
filename exl dde 'excel|system';
options noxwait noxsync;
x "'C:\Program Files\Microsoft Office\Office15\EXCEL.EXE' &macDrv.\&macBook";
06-08-2016 02:56 PM
If it stopped working and worked before it's likely not the code.
Verify that nothing else has changed, permissions, SAS settings, security settings, version of Excel, and path of file.
06-08-2016 05:07 PM
SAS called macro fine previously with this code and doesn't now? Is that correct?
If so, something else is the issue.
Figure out what changed between last run and this and test each change.
06-08-2016 03:03 PM - edited 06-09-2016 10:34 AM
I have found at least one other application, Cisco Jabber, that if running interferes with dde calls and have anecdotal evidence there may be others. In the case of Jabber it is not sufficient to stop running the program but you have to use task manager to kill the process.
So you may check with your IT folks about any new or updated program installed since the last time you successfully ran the SAS program.