Command to automatically override existing databases/files

Hi Mike,

Sorry for not getting back to you sooner.  The command you are looking for is:

IgnoreWarning(True)

Just add this at the beginning of the script and you won't get any pop-ups asking you to overwrite files that already exists.

Brian

Hi all,
I have used IgnoreWarning(True) in a script, which successfully overwrites the existing databases, but does not overwrite exported files.
Should exports be overwritten when using IgnoreWarning(True)?
If not, is there any other way to accomplish this?

Hi JHDCC, when they were putting the scripting language together they decided not to add that function, the reason for that is probably lost in time.

What you can do is first check if the file exists and if it does delete it manually before doing the save.  Here is some code for you to do it.

Sub Main
	Call deleteFileIfExists("C:\Users\User\Documents\My IDEA Documents\file to delete.xls")
End Sub

Function deleteFileIfExists(sFilename As String)
	Dim fso    
	Set fso = CreateObject("Scripting.FileSystemObject")
	
	If (fso.FileExists(sFilename)) Then
		fso.DeleteFile sFilename
	End If
End Function

Thanks Brian
For the benefit of anyone else picking this up, rename the path in this line with the file you want to delete and include this in the top of the macro between the Sub Main and End Sub lines. Include a seperate line for each file which is to be deleted.
<code> 
Call deleteFileIfExists("C:\Users\User\Documents\My IDEA Documents\file to delete.xls")
</code> 
Include the below in the body of the macro. This does not need altering and only needs including once it seems - I presume the file path in the top section is inserted into the  function and it runs for  each instance.
<code> 
FunctiondeleteFileIfExists(sFilename As String)DimfsoSetfso = CreateObject("Scripting.FileSystemObject")If(fso.FileExists(sFilename))Thenfso.DeleteFilesFilenameEndIfEndFunction
</code>