Renaming an External File

[phil_w]

Hi,

I have an access database and in the VB code I want to rename an external file. ie. a text file on my c:\ drive is called 'test.txt' and i then want to rename it via vba to 'complete.txt'.

Anyone know how this is done, or if I need to make sure I have a correct library registered etc.?

Thanks

[si_the_geek]

I'm not sure if it's the same in VBA, but in VB this would do it:

Name "C:\test.txt" as "c:\complete.txt"

[phil_w]

Originally posted by si_the_geek
I'm not sure if it's the same in VBA, but in VB this would do it:

Name "C:\test.txt" as "c:\complete.txt"

works, thanks very much. thought i tried that but obviously not.