How do I open and update excel spreadsheet from AS400? - TechRepublic
Question
October 12, 2011 at 07:56 AM
chriscpbucc

How do I open and update excel spreadsheet from AS400?

by chriscpbucc . Updated 14 years, 8 months ago

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 discussion is locked

All Comments