Renaming an External File

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

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

VB Code:

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

Quote:

---

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

VB Code:

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

---

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