Hi,
I am creating a text file through Macro.
on closing that file I alwyas get a dialogue box.
how to avoid that dialogue box.

Precede with

Application.DisplayAlerts = False

and reset at the end

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kapil" wrote in message
...
Hi,
I am creating a text file through Macro.
on closing that file I alwyas get a dialogue box.
how to avoid that dialogue box.