Don
I've changed the info as follows and created relevant directories:

Sub movefile()

OldName = "C:\Test\Active\Test1.xls"
NewName = "C:\Test\Complete\Test1.xls"
Name OldName As NewName

End Sub


"Don Guillett" wrote:

I did provide an example. Perhaps you could give the info on the path and
file name for old and new??

--
Don Guillett
SalesAid Software

"Sadcrab" wrote in message
...
Sorry Don I still can't get it to work can you supply an example

"Don Guillett" wrote:

This does work. Just change oldfolder to your desired folder and oldname
to
your file name, etc. Then fire.

--
Don Guillett
SalesAid Software

"Sadcrab" wrote in message
...


"Don Guillett" wrote:

maybe this simple idea will help?
Sub movefile()
OldName = "C:\oldfolder\oldname.xls"
NewName = "C:\newfolder\newname.xls"
Name OldName As NewName
End Sub


--
Thanks Don but I can't get it to work. I get a runtime error 53 File
not
found more help on this please. Thanks