Delete a file from export folder

Hi Jiyajijp,

Yes there is.  A access the Scripting.FileSystemObject that I believe is part of windows which allows you to do lots of different things at the file level.  This code will first check to see if the file exists, it then closes it (it needs to be closed in IDEA before being deleted) and then deletes it.  So you just need to send the path and filename of the file for this to work.

Brian

Sub Main
	Call DeleteFileIfExists("D:\Projects\MyFile.IMD")
End Sub

Function DeleteFileIfExists(sTempFilename As String)
	Dim fso As Object
	Set fso = CreateObject("Scripting.FileSystemObject")
		If (fso.FileExists(sTempFilename)) Then
			Client.CloseDatabase sTempFilename 
			fso.DeleteFile(sTempFilename)
		End If
	Set fso = Nothing
End Function

You should be able to delete the file anywhere with that could assuming it is not in use.  Just send the path to the library section along with the name of the file and it should work.