Re: How to Execute Excel from SQR ??

[Rosie ODonnell <joe.patton@NA.MARCONICOMMS.COM>]

John,

I just tried your solution in a program that I am working on, and it works
perfectly.  I have one additional question.  I used your example to launch excel
and open the csv file that my sqr created.  Excel launches and opens the file,
but the sqrw communications box is still open in the background with the 'End of
Run' message displayed.  Is there a routine that my program can call that would
automatically close the communications box immediatly after the 'CALL SYSTEM'
line?

Joe Patton
Marconi Communications




John Sayre <John_Sayre@GAP.COM> on 07/08/99 11:13:37 AM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Joe Patton/LLP/RELTECCORP)

Subject:  Re: How to Execute Excel from SQR ??




From: John Sayre@GAPINC on 07/08/99 08:13 AM
I have been able to do this with the following commands:

LET $CALLSTR='X:\MSOFFICE\EXCEL.EXE -S H:\EXCEL\FORMAT.XLS'
CALL SYSTEM USING $CALLSTR #RETURN_VALUE







Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: John Sayre/SB/GAPINC)
Subject:  How to Execute Excel from SQR ??




Hi gurus.....

I have created SQR that produces a tab-delimiter file and then I need to open
it in Excel SpreadSheet.
How Can I call the Excel from the SQR ???
So when the SQR finishes produce the output, I want to call Excel and open the
output file in excel ??
I've tried the Call System, but still cannot work.

any suggestion would very appreciated !!

regards
Hartono Sutirman