save without prompt

  1. S

    closing excel without saving - not working properly

    I have two documents. sourcedocument and fulldatafilename. I pull data from the fulldatafilename, paste into sourcedocument and then close source document. I can open fulldatafilename and work with it and even switch between the sourcedocument. but I can not seem to close the...
  2. P

    Quit excel after macro without saving

    I'm trying to put the finishing touches on a time sheet I've made. So far I've got a macro working to convert it to a PDF and email it, but I would like to add another feature. I would like to add some VBA code at the end of the macro to quit the excel application without saving it so that when...
  3. L

    VBA - How to Save and Close without prompt

    Hello, I have the following line of VBA code within one of my macros. ActiveWorkbook.SaveAs Filename:="C:\LH1\" & flname, _ FileFormat:=xlCSV, CreateBackup:=False ActiveWorkbook.Close The macro opens up a new file, copies data into it, saves it as a .CSV, and then closes...

Some videos you may like

This Week's Hot Topics