Good morning, At a prior company I was able to open an Excel template by using DDE. Once the file was open data could be output the appropriate tab and cell location. Today I have discovered that my DDE code does not work. Something to the effect of the server is not permissioned for Excel or Access. SAS is located on a non-Windows server. My question is this. Is there a method to open my existing Excel template without using DDE? Sample Code: * INITIATE EXCEL *; options noxwait noxsync xmin; filename sas2xl dde 'excel|system'; data _null_; length fid rc start stop time 8; fid = fopen('sas2xl','s'); if (fid le 0) then do; rc = system('start excel'); start = datetime(); stop = start+10; do while (fid le 0); fid = fopen('sas2xl','s'); time=datetime(); if (time ge stop) then fid = 1; end; end; rc=fclose(fid); run; * Issues occurring with timing, Implementing sleep *; data _null_; slept = sleep(5); run; Thank you in advance for your help. It is appreciated. Kirk
... View more