This code kicks back asking if I want to overwrite the existing file with the same name. How do I tell it yes. and do it every time? Please advise and thanks. -R-
myDirECTorY = "C:\_SAP\ShortageRpt\DefaultExtractFiles\" 'Wherever you want
'myFileNameO = myDirECTorY & Format(Now(), "yyyymmdd_hhmm") & " ZSHORTV2DataCurrent" & ".xlsx" 'File name as desired.
myFileNameO = myDirECTorY & " ZSHORTV2DataCurrent" & ".txt" 'File name as desired.
'Add text to column here
ActiveWorkbook.SaveAs Filename:=myFileNameO, FileFormat:= _
MsgBox (" Done file saved ")