Two options:
1. Use the 'close without saving' parameter when you close the file.
2. Use sendkeys to answer the question.
The first seems better.
Kees
Hi,
I am sure this is really simple, but I can't work it out or find the answer anwhere.
I have a macro that opens a workbook, switches to an other work book, changes links to the workbook just opened, and then closes it.
It repeats this for about 12 files.
Problem is each time it shuts the workbook, a message appears saying Save Yes/No ?, and I have to click no, which defeats the whole point of the macro, in that I can't leave it to run unatended.
How do I make the macro answer the message box by selecting 'No' ?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic