K
Kim Wim
I cannot determine how to write the language to overwrite
the existing file when performing "active workbook, file
save as".
Visual basic does not recognize overwrite:=true.
Or I may have not entered it in the correct place in the
code.
I currently have:
ActiveWorkbook.SaveAs FileName:="I:\LOCALGVT\Temp\2001
Trans\transmitz.xls" _
, FileFormat:=xlExcel5, Password:="",
WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False,
Overwritefile:=True
Any help is appreciated.
the existing file when performing "active workbook, file
save as".
Visual basic does not recognize overwrite:=true.
Or I may have not entered it in the correct place in the
code.
I currently have:
ActiveWorkbook.SaveAs FileName:="I:\LOCALGVT\Temp\2001
Trans\transmitz.xls" _
, FileFormat:=xlExcel5, Password:="",
WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False,
Overwritefile:=True
Any help is appreciated.