Re: How to Execute Excel from SQR ??

[Gracen Duffield <gduffiel@TDHCA.STATE.TX.US>]

have you tried this (i don't know if it will work):
     1. export data comma delimited file with a .cvs extension
     2. write a batch file that launches excel and passes it
        the .cvs file to open
        the syntax (i think) is
        [full path of excel.exe] [full path of input file]
        example:
        C:\Program Files\MSOffice\Office\excel.exe c:\work\data.cvs
    3.  use call system to call the batch file from the sqr.

Gracen Duffield
Texas Department of Housing and Community Affairs
475-3839


-----Original Message-----
From: Juan Alvarado [mailto:juan@GYSSA.COM.GT]
Sent: Thursday, July 08, 1999 8:19 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: How to Execute Excel from SQR ??


You can try the CVS option , that produce a button in the report that
when run the report a push the button automatic startup excel or
whatever you have relation with and cvs.

I hope this help you

-----Original Message-----
From: Hartono Sutirman [mailto:hsutirman@JATIS.COM]
Sent: Thursday, July 08, 1999 4:48 AM
To: Multiple recipients of list SQR-USERS
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