Re: Output from PF to Excel XLS file in IFS

[meovino@xxxxxxxxxxxxxxxxx]

> What is the appeal of locking into a Windows solution like VB?

None in my mind (I know that might not be directed at me).  The program
that creates the PF is on a 400.  The PF is on the 400.  The program that
e-mails files in the IFS is on this 400 (granted, it could live anywhere,
but it doesn't; it lives on the 400 and is called from a 400 command).
Unless VB programs themselves could run on the 400, I don't see what using
VB buys me, if I can get something that will output from a PF to an XLS
file in the IFS and is command driven so we can run this in a scheduled
job.

I downloaded the Kemetech stuff and I'm playing with it, and it looks
pretty sweet.  The field I'm having trouble with is an alpha field in the
PF, and in the XLS file it's output as text.  Just what I want.

> If you want
> MS Solutions wouldn't you be better off to just use MS in the first
place?

My customers want Excel files.  I can try to explain to them that the CSV
file is just fine, open it in Notepad and you'll see that all the data is
there.  They don't care.  It looks wrong in Excel, therefore, it is wrong
and I am wrong.

> Mike E, VARPG will write directly to Excel spreadsheets on any drive on
the
> LAN.  It uses RPGIV.

Can VARPG write code that runs in batch on the 400?  Remember, this is
being kicked off by an entry in the job scheduler.

> Heck, it will even open Excel on the user's desktop.

Now that might be fun to play with ;-)

Mike E.