Re: Excel File to Email

["Bill" <brobins3d@xxxxxxxxxxxxxxxx>]

> That is interesting, I'd done a custom report on our 400 that created an
> outfile for a co-worker who then created an excel sheet that would
> autoupdate with a few sorting parms. When he sent me the sheet I was
unable
> to even open it until he sent me the associated *.dqy file(s).
>
> M$ stuff is very YMMV based on which version of office you've got it
seems.

In this case it's just a matter of implementation.  MSQuery can create a
separate query definition, which would be required in order to have the
data update as needed, as you've experienced.  But, as I said, it can also
store the definition "inside" the worksheet.

Closest and quickest comparison would be the requirement of SQL/400 in
order to compile an RPG/SQL program, but isn't necessary to run the
program.

Bill