topic Re: Suppress Excel 2007 save changes prompt in SAS Programming

Suppress Excel 2007 save changes prompt

B_caapi — Tue, 20 May 2014 18:08:23 GMT

Does anyone know how to use the DDE system topic to suppress the save changes prompt I get when closing excel?

My code is:

%MACRO SAVEAS(FILE);

OPTIONS NOXWAIT NOXSYNC;

*** Open Excel file ***;

x "start excel";

data _null_ ; x = SLEEP(2) ; run ;

filename cmds DDE 'excel|system' ;

data _null_ ;

file cmds ;

string1 = '[FILE-OPEN("'||"&dir.\&&FILE..xls"||'")]';

put string1;

PUT '[ERROR(FALSE)]';

string5 = '[save.as("'||"&dir.\&&FILE..txt"||'",3)]';

put string5;

put '[QUIT()]' ;

RUN;

%MEND SAVEAS;

I'm trying to add a control program to run 6 sets of code but it stops each iteration and waits for me to click "no" before moving on.

B_caapi — Tue, 20 May 2014 18:23:47 GMT

Windows 7 enterprise, 32-bit

SAS 9.2 TS Level 2M3 W32_VSPRO platform

Reeza — Tue, 20 May 2014 18:56:27 GMT

Close the file before quitting, specifying save or not save. Not sure how you specify the logical.

I think I've used

put '[close(0)]';

Or it could be:

put '[close(FALSE)]' ;

B_caapi — Tue, 20 May 2014 19:08:08 GMT

Thanks Reeza. put '[close(0)]'; worked.