Software·43,780 discussions

How do I open and update excel spreadsheet from AS400?

Locked

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?

Topic

Clarifications

In reply to How do I open and update excel spreadsheet from AS400?

Clarifications

Does the second line work from the PC itself?

In reply to How do I open and update excel spreadsheet from AS400?

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.

Reponse To Answer

In reply to Does the second line work from the PC itself?

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

You’ll have to name the node as well.

In reply to How do I open and update excel spreadsheet from AS400?

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.

[Author]

Replies