assigning a drive to the 400

[Guest.Visitor]

Actually this gets more difficult!! The full scenario is as follows. At the present a user will take an option off a green screen, this will create an AS400 file. they then run a download (DTF / TTO) this downloads the file onto their PC. They then launch XL to open the file. THis works fine but takes 3 steps. I want to automate it if I can. I can run a PC cmd from the green screen that will move the file to the IFS and convert it , then launch XL to open it. Problem is I can only do this as type CSV. I really want XLS - any ideas???

[Guest.Visitor]

Hi, I want to create a folder on my As400 and then create CSV type files from my database. I want a pc to be able to assign the folder and download the csv file. I would like the PC to have the drive mapped automatically . Is this possible?

[David Abramowitz]

Have you tried using the STRPCO and STRPCCMD commands to automate the file transfer process? Dave

[Guest.Visitor]

Just download the file directly into Excel via the Microsoft Query add-in that is optionally installed off of the Office CD. Bill clongley wrote: > Actually this gets more difficult!! > The full scenario is as follows. At the present a user will take an > option off a green screen, this will create an AS400 file. they then > run a download (DTF / TTO) this downloads the file onto their PC. > They then launch XL to open the file. THis works fine but takes 3 > steps. I want to automate it if I can. I can run a PC cmd from the > green screen that will move the file to the IFS and convert it , then > launch XL to open it. Problem is I can only do this as type CSV. I > really want XLS - any ideas???