Excel-VBA (ActiveWorkbook.SaveAs )
Kan man på nogen måde undgå at følgende meddelelse kommer :\"A file named \'salg_tmp.xls\' already exists in this location. Do you want to replace it?\"
Sub salg_1()
Workbooks.Open FileName:=\"\\\\GLY001\\group\\Drift\\Pdox\\brj\\salg.xls\"
Workbooks.Add
ActiveWorkbook.SaveAs FileName:=\"salg_tmp.xls\", FileFormat _
:=xlNormal, Password:=\"\", WriteResPassword:=\"\", ReadOnlyRecommended:= _
False, CreateBackup:=False
End Sub
Version : Excel 97 SR-2
WetDog