Re: Closing output file

["Weaver, Judith R" <WeaverJR@USAFOO.UNITEDSPACEALLIANCE.COM>]

That's interesting, because I successfully open an output file in Excel at
the end of an sqr by simply closing the file prior to calling Excel.  We are
using Windows 95.  The code is like this:

do procedure_1          !this gathers the data and writes the file
close 1
do excel_demo
!--------------------------------
begin-procedure excel_demo

   LET $COMMAND = GETENV('COMSPEC')
                  ||' /c "c:\program files\microsoft
office\office\EXCEL.EXE" '
                  ||$filename
   CALL SYSTEM USING $COMMAND #S

end-procedure excel_demo
!--------------------------------

-----Original Message-----
From: Paul Schattling [mailto:P.Schattling@MAILBOX.GU.EDU.AU]
Sent: Wednesday, October 25, 2000 2:58 AM
To: SQR-USERS@list.iex.net
Subject: Closing output file


Hi guru's,

Tools 7.5, Oracle

Is there a way to close the output file that you have open while running an
sqr (usually the <program_name>.lis file) before the sqr finishes?
I know that you can control a predefined file using the OPEN and CLOSE
commands, but this is an existing (lengthy) PeopleSoft process and I don't
particurlary want to re-write it.
Once the program has finished writing the data to the output file, I want
to add a final step that launches an outside application and uses that file
that was just created, in it. However it appears that I can't access that
file because it's locked/non there because the sqr program still has a bar
on it.

Cheers,
Paul