<div>
<div class="content wysiwyg-content">
I am developing an Access application with Access VBA. 
 
How to handle the message: Run time error '58 &quot;File already exists&quot; when renaming a file to an existing file name. Is there a way to send a MsgBox with this error instead of the Microsoft Visual Basis run time error being generated ? 
 
For ex: 
 
sfile = &quot;\\nydfs1\root\lib\CONTROLLERS\IIG\CASH_CONTROL\ccshared\AbandonedProperty\UDL\Access\UDLLexisNexis\Morgan_Stanley_UDL_LN_prc&quot; &amp;&nbsp;&quot;.xls&quot; 
 
If isFileExist(sfile) Then 
&nbsp; &nbsp; Name sfile As Left(sfile, Len(sfile) - 4) &amp;&nbsp;&quot;_&quot; &amp;&nbsp;Format(Date, &quot;yymmdd&quot;) &amp;&nbsp;&quot;.xls&quot; 
End If 
</div>
</div>

I am developing an Access application with Access VBA.

How to handle the message: Run time error '58 "File already exists" when renaming a file to an existing file name. Is there a way to send a MsgBox with this error instead of the Microsoft Visual Basis run time error being generated ?

For ex:

sfile = "\\nydfs1\root\lib\CONTROLLERS\IIG\CASH_CONTROL\ccshared\AbandonedProperty\UDL\Access\UDLLexisNexis\Morgan_Stanley_UDL_LN_prc" & ".xls"

If isFileExist(sfile) Then
    Name sfile As Left(sfile, Len(sfile) - 4) & "_" & Format(Date, "yymmdd") & ".xls"
End If 

How to handle the message: Run time error '58 &quot;File already exists&quot; when renaming a file to an existing file name ?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

How to handle the message: Run time error '58 &quot;File already exists&quot; when renaming a file to an existing file name ?

How to handle the message: Run time error '58 "File already exists" when renaming a file to an existing file name ?