Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting/overwriting an excelfile
Hi, I am using the following command to create a new excel file named
"Log.xls" (RetStr is defined above in the macro...) Dim dummy As String dummy = RetStr + "\Log.xls" Set newBook = Workbooks.Add With newBook .Title = "ErrorLogs" .SaveAs Filename:=dummy End With That works very good. But i need a routine that checks if the file already exists. And if so, delete/overwrite that file before creating it (again). Any hints? TIA Walt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overwriting a cell with a formula without deleting the formula | Excel Worksheet Functions | |||
Overwriting most of a workbook | Excel Discussion (Misc queries) | |||
Excelfile wants to save before closing | Excel Discussion (Misc queries) | |||
How do i lockup a locked excelfile if i have forgot the password? | Excel Discussion (Misc queries) | |||
Spreadsheets are overwriting each other | Excel Discussion (Misc queries) |