How to check if a file already exists 1

[SkyHigh]

I am trying the following routines in one of my functions and I get runtime error 424 :

If Not Object.FileExists(CurrentProject.path & "\Archives\Reports " & ccmonth & ".mdb") Then
fs.copyfile CurrentProject.path & "\" & CurrentProject.name, CurrentProject.path & "\Archives\Reports " & ccmonth & ".mdb"
End If

Thanks for your help !!
Brenda

 

[PHV]

Try to replace this:
If Not Object.FileExists(
By this:
If Not fs.FileExists(

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkyHigh]

Great PHV, your help is much appreciated.
Have a star !!
Brenda

 

[jimlee]

You may also find this helpful... faq707-4116

I did.

jimlee