Re: How to Execute Excel from SQR ??

["Sarabudla, Raji R." <Raji.R.Sarabudla@KP.ORG>]

Use -XCB flag in SQR Command line Flag, it prevents use of communication
box.  It pops up the windows dialog box, only when inputs are present in the
SQR program.

Hope it helps,

Raji

----------
From:  Rosie ODonnell [SMTP:joe.patton@NA.MARCONICOMMS.COM]
Sent:  Thursday, July 08, 1999 12:14 PM
To:  Multiple recipients of list SQR-USERS
Subject:  Re: How to Execute Excel from SQR ??

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