Yup, it's one of those "strange" queries.

I have a workbook that can create a report for numerous clients.
One Client wants to be able to see the up-to-date report whenever he
wants.
So that he cannot see any other client's reports i was hoping that
someone had some bright ideas of how to do this.

I was thinking that i could
* create a workbook that will produce a report for this client (this is
doable)
*each morning when i log in, it will automatically produce a report
with the most up-to-date data. (maybe startup? not sure though).
*After the report is produced another macro will save the report to a
webpage or folder (like yahoo briefcase) overwriting anything else that
has the same name. (is this wishful thinking?)

Any help or advice appreciated.

thanks
George