C
cosmo37
using this save as
ChDir "S:\docs here"
ActiveWorkbook.SaveAs Filename:="S:\docs here\" & _
Range("L8").Value & ".xls", FileFormat:=xlExcel9795, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
this works until i need a second file with same L8 data but dont want to
over write the first...
when i click NO to replace, i get runtime error 1004, method saveas of
object workbook failed
*** here is what i want, when i click NO i want the option to edit the file
name***
(would love it if it auto changed name to (L8)_1 if that is already there
then (L8)_2 and so on)
am i asking too much... can anyone help... thanks in advance
ChDir "S:\docs here"
ActiveWorkbook.SaveAs Filename:="S:\docs here\" & _
Range("L8").Value & ".xls", FileFormat:=xlExcel9795, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
this works until i need a second file with same L8 data but dont want to
over write the first...
when i click NO to replace, i get runtime error 1004, method saveas of
object workbook failed
*** here is what i want, when i click NO i want the option to edit the file
name***
(would love it if it auto changed name to (L8)_1 if that is already there
then (L8)_2 and so on)
am i asking too much... can anyone help... thanks in advance