Excel Close but not save file command

  • I've got a code the open's up multiple files but I need ot figure a cod that would close certain files after completion of the function done with that file. I have no idea how to close and not save the file is there a possible command that could do this function.

    Secondly I've always encountered this problem stating ...
    Microsoft Excel
    is there anyway i could expand the memory for microsoft excel or is it just a restriction set by Microsoft.


  • As for question one

    Application.DisplayAlerts = False

    or perhaps

    ThisWorkbook.Close SaveChanges:=False

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!