How do I open and update excel spreadsheet from AS400?

By ChrisCPbucc ·
I need to execute the following from within As400:

"c:\program files\IBM\Client Access\rxferpcb" mydtffile.dtf myname mypassword
"c:\program files\microsoft office\office11\excel.exe" es00pre2.xls

The above 2 lines is part of a bat file executed from within As400.
This spreadsheet has vbscript that will autimatically update the spreadsheet.
The problem is that the second line causes an indefinte time wait on the AS400.

any assistance please?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Does the second line work from the PC itself?

by robo_dev In reply to How do I open and update ...

It would only work if the XLS file is in the \office11\ folder, no?

I would put an IF EXIST loop in there to check for the file first, then error out if it's missing.

Collapse -

Reponse To Answer

by ChrisCPbucc In reply to Does the second line work ...

The bat file contains the following lines. I have modified line 5 to include the full path of the XLS file, but it did not resolve the problem. I have verified that the XLS file is created and put in the folder by the line 4 statement....

"c:\program files\IBM\Client Access\rxferpcb" ESA002F2.dtf bicc Sailfish1
"c:\program files\microsoft office\office11\excel" c:\biccspreadsheet\es00pre2.xls

Collapse -

You'll have to name the node as well.

by seanferd In reply to How do I open and update ...

The C: drive on which computer is going to be important, assuming you haven't taken care of this elsewhere.

Also, Excel has to know where to find the file, so if it is outside of the default dirs excel looks, you'll have to specify.

Related Discussions

Related Forums