Re: How to Execute Excel from SQR ??

[Clara Carter <clarac@RAINMAKERSYSTEMS.COM>]

Hi,

I didn't know sqr could do this so I just learned something new but
I am wondering why or what would you use this for?

Clara

At 12:13 PM 7/8/99 -0400, you wrote:
>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