Re: How to Execute Excel from SQR ??

[John Sayre <John_Sayre@GAP.COM>]

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