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