Save window problem

[mg_reich]

I have written a macro in a workbook that opens up different files and copies information and pastes it into a sheet in the current workbook. When the macro closes the files after it copies the data a "Do you want to save" message box pops up. The macro goes through several sheets so this window pops up 10+ times. It really doesn't matter if the files are saved at that time, b/c nothing has been done with them. I basically just don't want the save windows to pop up. I thought there might be something set differently with the properties of the file somewhere. Even if I just open one of the files and do nothing to it and close it again, I get the save message box.

Any ideas would be greatly appreciated.

Thanks in advance.

 

[KMKfan]

Your macro probably has a

.Close

command. You can type SaveChanges:=False on that line and you will not get the Save As dialog.

ActiveWindow.Close SaveChanges:=False

 

[mg_reich]

Thanks

Thanks...works great