How to Execute Excel from SQR ?? - Solved

[Hartono Sutirman <hsutirman@JATIS.COM>]

Thank you for all your suggestion. Finally I solved the problem.
The command I use is :
    LET $COMMAND = GETENV('COMSPEC') || ' /c EXCEL.EXE C:\TEMP\REPORT.LIS'
    CALL SYSTEM USING $COMMAND #S

By the way, I using SQR 4.3 on ORACLE 7.3.3 database and the Operating System is
Windows NT 4.0

thanks everyone....
regards,
Hartono Sutirman

Nathan Stratton Treadway wrote:

> On Thu, Jul 08, 1999 at 05:48:26PM +0700, Hartono Sutirman wrote:
> > 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.
>
> You haven't given the list enough information to help you.
>
> You'll probably have better luck if you include the following
> information in your post to the mailing list:
>   * what version of SQR you are using
>   * what operating system you are running on
>   * what you have tried to do (you might want to include the
>     lines of your SQR program related to your problem)
>   * what you mean by "still cannot work".  (Did you get an error
>     message?  Did the SQR program run but Excel simply did not start?)
>
> It should be possible to do what you want, I think, but you'll have to
> give us more information before we can tell you what's wrong....
>
> (Please post another message to the mailing list with this information.)
>
> Good luck.
>
>                                                 Nathan
>
> ----------------------------------------------------------------------------
> Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
> nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/