none
simple code for save as if file already exsist

    Question

  • Hi I got this simple code to just do a save as:

    Sub SAVE()

    ThisWorkbook.SaveAs "d:\My Documents\filling_stocktake" & Format(Date, "yyyymmdd")


    End Function

    now i encounter the problem when the file exsist and i just want it to save , i get the error when i hit cancel or no

    what iwant  it to do when i hit no or cancel go to the save macro i have got.

    which is:

    Sub SAVE1()
    ThisWorkbook.SAVE
    End Sub

    thanks

    Saturday, June 08, 2013 12:50 AM

Answers

All replies