i need function to check if exist file name in folder

thanks



Norman Jones wrote:
Hi Yuvalbra,

1. need macro for create new email message and send it.

See Ron de Bruin's extensive range of email code at:

http://www.rondebruin.nl/sendmail.htm


2. need macro that rename file , delete file.

'=============
Public Sub Tester()
Const sFilename As String = "OldName.xls" '<<=== CHANGE
Const sNewName As String = "NewName.xls" '<<=== CHANGE

Workbooks(sFilename).SaveAs sNewName
Kill sFilename

End Sub
'<<=============


---
Regards,
Norman