close without saving

[alring]

I have made a macro in Excel 2003 that open and print another Excel document. Now I want the same macro to close that document I opened and printet. But it have to close without saving. I have tried to record it but then I'm ask if I want to save. I'm trying to avoid that quistion.

regards
Mads

 

[TomCologne]

How about something like this:

Sub OpenClose()
'
Workbooks.OpenFilename:="C:\Xyz.xls"
'' Modify this workbook:
'' Put code in here

ActiveWindow.Close (False)
    
End Sub

TomCologne

 

[alring]

Hi TomClogne

Thank you. It works.

Mads