Re: Output from PF to Excel XLS file in IFS

["Bill" <billzbubb@xxxxxxxxxxxxxxxx>]

Fisher, Don wrote:
> The only way I know of to accomplish this is to use a language like
> Visual Basic to retrieve the data from your physical file and place
> it into an Excel spreadsheet.  I wrote some RPG and CL programs that
> would build the physical file and then execute the Visual Basic
> program residing on a Windows server using RUNRMTCMD.

I would second this as a solution.  You could completely automate the
process utilizing MS Query (an optionally installed component of Office)
and Visual Basic for Applications (which is included with Office.

I have created many spreadsheets that download data, some even reformat the
data into a presentation format, and then mail themselves.  I haven't
created any that autoexecute but that's a minor consideration.

Bill