Hi Rob,
I don't have an answer to you question, but I think you may beable
to answer one for me, please email me at you earliest convenience....
Thanks..

(Rob) wrote in message . com...
Hello All,
I run an excel 2000 application .This macro is used to
generate few reports on a daily basis.I use a template for these
reports and I run this excel script from an Access application and
have automated it so as to run everyday at a scheduled time.Everything
is fine and the reports are saved on the screen with the current
date.But i want them to be directly saved into their respective
folders of the directory instead of on the screen.(At present,after i
reach the work place,I click each of these reports and a message asks
me whether the report has to be saved ).Can this be over ridden?
Thanks for your replies.


Rob