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
    NOT ENOUGH MEMORY
    is there anyway i could expand the memory for microsoft excel or is it just a restriction set by Microsoft.


    Thanks,
    PP

  • As for question one


    Application.DisplayAlerts = False
    ActiveWorkbook.Close


    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!