Below is a macro i have made that saves the file name like i want it too
using data from the worksheet. The problem is if they file name has
been used before, which it shouldnt have but could have accidently been
saved, it asks if you would like to save over this. if you click no
then it crashes.
Is it possible to set it that if u click no it just ends the macro.
thanks
Sub SAVEAS_NEW_FNE()
Dim FN As Workbook
Dim D As Variant
[D] = Format(Range("B3"), "mm_dd_yyyy")
ThisWorkbook.SaveAs Filename:="FNE " & [D]
End Sub
--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile:
http://www.excelforum.com/member.php...o&userid=24271
View this thread:
http://www.excelforum.com/showthread...hreadid=538749