Automation between Iseries and Excel

I came up with a solution to automate the creation of an Excel
spreadsheet with current I-series information. Without boring you with
the details; has anyone found a way to open an Excel spreadsheet off
hours without being logged on?

The code below is part of a CL program I wrote to open an Excel
Spreadsheet. Once I opened the Excel Spreadsheet, the Auto_Open Macro
took care of the rest. Everything worked great until I tried to
schedule the CL program with iSeries Navigator. I found out the hard
way that STRPCO and STRPCCMD only work interactively. Any suggestions.

/* 1. Open Excel Spreadsheet */
/*******************************/

STRPCO PCTA(*NO)
MONMSG MSGID(IWS4032) EXEC(DO)
GOTO CMDLBL(ENDCLPGM) /* not a PC */
ENDDO
MONMSG MSGID(IWS4010) /* already started = OK */

STRPCCMD PCCMD('start excel.exe M:/bcpobo.xls') +
PAUSE(*NO)

Is your question

1) how to remotely log onto a windows machine bypassing the Ctr/Alt/Del?????

Or
2) log on with a user/password combo
do stuff and
log off

"kta@mysticstamp.com" wrote:

> I came up with a solution to automate the creation of an Excel
> spreadsheet with current I-series information. Without boring you with
> the details; has anyone found a way to open an Excel spreadsheet off
> hours without being logged on?
>
> The code below is part of a CL program I wrote to open an Excel
> Spreadsheet. Once I opened the Excel Spreadsheet, the Auto_Open Macro
> took care of the rest. Everything worked great until I tried to
> schedule the CL program with iSeries Navigator. I found out the hard
> way that STRPCO and STRPCCMD only work interactively. Any suggestions.
>
> /* 1. Open Excel Spreadsheet */
> /*******************************/
>
> STRPCO PCTA(*NO)
> MONMSG MSGID(IWS4032) EXEC(DO)
> GOTO CMDLBL(ENDCLPGM) /* not a PC */
> ENDDO
> MONMSG MSGID(IWS4010) /* already started = OK */
>
> STRPCCMD PCCMD('start excel.exe M:/bcpobo.xls') +
> PAUSE(*NO)
>
>