File not found while trying to rename - Name XXX As XXX

[CTOROCK]

Hello,

i am getting an error of Runtime '53' File not found while trying to relocate and rename a file. I use:

Name "C:\My Documents\Eric\Programs\Commissions\Customer Query.xls" As "C:\My Documents\Eric\Programs\Commissions\Customer Query 06/08.xls" '"C:\My Documents\Eric\Programs\Commissions\Customer Querries Old\Customer Query " & Format(Date, "mm/yy") & ".xls"

I was sure this was the method to use but I get an error when trying to rename it. Thanks in advance for any help

The greatest risk, is not taking one.

 

[Remou]

Try changing this: 06/08.xls

I am fairly sure that / is not allowed in a file name.

 

[CTOROCK]

Thanks Remou. You were right!

The greatest risk, is not taking one.