rename file error 1

[Johnny42]

sub rename()
Name "C\test.text" As "C\testbck.text"
end sub

I'm getting a file not found....what am I doing wrong ?

 

[PHV]

Name "C[highlight]:[/highlight]\test.text" As "C[highlight]:[/highlight]\testbck.text"

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

 

[Johnny42]

sorry...yes I posted wrong...
Name "C:\test.text" As "C:\testbck.text"
still gives me that error .....?????

 

[PHV]

C:\test.text" should exists
"C:\testbck.text" should not

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

 

[Johnny42]

Yes that is so......
do I have to ChDrive "C" because my workbook is on E drive ?