Skip prompt when closing a file within a macro

[lj50v]

Hi there,

I was wondering if anyone knows how to stop the message 'Do you want to Save <filename>', when you close a file from within a macro.
Up to now I have just had to let the user say 'Yes' or 'No' but it would be nice to just be able to do it without confusing the user.

Thanx in anticipation

lj50v

 

[Gavona]

From VBA help (help is your freind!)

Workbooks("BOOK1.XLS").Close SaveChanges:=False

Gavin

 

[WaterSprite]

I was taught, by this forum:

Application.DisplayAlerts = False

Just have to be careful when and how it is used.

 

[fumei]

Up to now I have just had to let the user say 'Yes' or 'No' but it would be nice to just be able to do it

Hmmmm, does that mean a decision needs to be made? Saved, or not saved? Is it up to the user?

If the decision (either way) is up to YOU, the developer, then yes you can do it (either way). However, if it does need to be saved, make sure you do so before you use:

Workbooks("BOOK1.XLS").Close SaveChanges:=[b]False[/b]

"A little piece of heaven
without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry