Code for "Do Not Save" Book1 in visualbasic macro

[mike]

I have a macro that copies the contents of Book1 into
another file then closes Book1. I don't want to save it
but I keep being asked if I want to. How do stop this
via code? I know it's easy if you know already, but I
don't. Thanks Mike

 

[Ron de Bruin]

If the code is in Book1 then you can use this
to close the file without saving

ThisWorkbook.Close False

 

[Mike]

-----Original Message-----
If the code is in Book1 then you can use this
to close the file without saving

ThisWorkbook.Close False


--
Regards Ron de Bruin
http://www.rondebruin.nl


"mike" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

Try

Windows("Book1.xls").Close False