Automation between Iseries and Excel

[kta]

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)

 

[Guest]

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