DDE to Excel

[shenniko]

Hi All,

Need a little bit of help/info.

I'm trying to setup some automation with the reports in my new workplace which uses Excel and DDE quite heavily.

Now using DDE to enter data into a worksheet isn't a problem when using the triplet, but the problem I've bumped into is Saving and closing the Workbook when there are two SAS sessions running.

So Scenario:

Excel is already open,
SAS autoruns calls two reports that both use DDE,

They export the data fine as they use the Triplet
Example:

FILENAME xlout DDE 'Excel|[Daily Report - Template.xls]Summary!R25C19:R55C19';
DATA _NULL_;
    FILE xlout;
    SET work.trans19;
    PUT expected_payments;
RUN;

But the code I have to save and close the workbook is

FILENAME xlout DDE 'excel|system';
DATA _NULL_;
    LENGTH x $2000;
    FILE xlout;
    PUT '[ERROR(FALSE)]'; 
    x= '[SAVE.AS("'||"&Statfile"||'",1,"",FALSE,"",FALSE)]';
    PUT x;
    PUT '[CLOSE()]';
run;

So depending on the active workbook at the time, SAS would save the Active worksheet and close that Worksheet (even though it might not be the right one).

I think what im asking is, how can I tell SAS which Worksheet I want to save and close?

Many thanks in advance

Robbie