VBA code close file without saving

[jpar1983]

I have basically three files that I'm working with to copy account data and everything is working fine, I just want to change one tiny thing, because I'm just lazy and don't want to click an extra time with the mouse . Anyway, I have one Inventory Log (file #1) file that I start with. I run a macro that opens a Secondary Log (file #2) and transfers some information off of each sheet in the Inventory Log to corresponding sheets within the Secondary Log. Then each sheet in the Secondary Log is copied to its own file (file #3) and saved with a name and date (surprisingly easy to do, I was amazed!). Each of these final files is then closed. Because they have already been saved I guess Excel doesn't prompt for a save. Finally I also want to close the Secondary Log (file #2) file that I have without saving it. The Inventory Log (file #1) will stay open. So far the only code I have is:

Activewindow.Close

My usual go-to is to record a macro, do what I want, and the just copy and paste the code with and necessary modifications. In this case, Excel did not pick up on my "No" click in the save prompt, so no code. Anybody have any ideas? Thanks!

Jeremy

 

[Smitty]

Welcome to the Board!

To close a workbook without saving you can use:

ActiveWorkbook.Close False

Conversely, changing False to True would save it.

HTH,

 

[jpar1983]

Perfect, thanks! This is going to save me so much time!