save & close with VBA

[kgkev]

I'm currently using

With wb
            .save
            .Close
End With

Is there a more effient way of doing this as it takes some time. Could a Save & close be done at the same time.

Alternatively how do you close without saving - Without getting a prompt asking if I want to save changes?

 

[VoG]

You can use

wb.Close savechanges:=True

Change the True to False to close without saving.