Re: How to Execute Excel from SQR ??

[John Sayre <John_Sayre@GAP.COM>]

From: John Sayre@GAPINC on 07/08/99 11:48 AM

In my case, our HR admin people need to create list of people at review time
and their current salary information & most recent promotion information.  We
are
~125,000 full & PT employees.  There is a tree structure in how our cost centers
roll
up to our 8 divisions.  The HR admin people plug a division into a PS panel
which
runs a SQR. The SQR creates a text file for each cost center in the division.
Then we run Excel,
and open , automatically, a spreadsheet with an auto_run macro. This spreadsheet
opens
each of the text files just created, converts each text file into an
spreadsheet, saves the spread sheet
and then deletes the text files.  The new mini-spreadsheets, 1 per cost center,
are emailed to the
manager of the cost  center.

This saves the HR admin folks from having to manually open a bunch a text files
in Excel,
maniplulate them and save them.   Also we can format them really pretty on the
fly and
easily set protection on fields that should not be changed.

In general, our users hate .lis files and convert them to Excel, anyway.
I just wrote a general purpose XLS to open any text file we write from SQR
and format it for the users with no intervention on their part.




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:  Re: How to Execute Excel from SQR ??




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