Software

Ask something
Question Locked

How do I open and update excel spreadsheet from AS400?

0 helpful
4 replies

by chriscpbucc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

4 replies

by robo_dev

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.

by chriscpbucc

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....

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

by seanferd

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.

This discussion is closed to new replies.