If I write a Macro to open another file, and copy data out of it, then close
it, is there a way to prevent the message box of "Do You Want to Save the
Changes You Made...," so that the end user does not need to click on "No"
each time?

As always, your help is greatly appreciated.

Thank You.

Couple of ways

Application.DisplayAlerts=False

At the start of your code and True at the end or any possible exit point

If you don't want it saved

Workbooks("myWorkbook").Saved=True

Makes Excel think it is clean

If you want it saved

Workbooks("myWorkbook").Save

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"HROBERTSON" wrote in message
...
If I write a Macro to open another file, and copy data out of it, then
close
it, is there a way to prevent the message box of "Do You Want to Save the
Changes You Made...," so that the end user does not need to click on "No"
each time?

As always, your help is greatly appreciated.

Thank You.