Would you believe it's this easy

Sub movefile()
OldName = "C:\oldfolder\filename.xls"
NewName = "C:\newfolder\filename.xls"
Name OldName As NewName
End Sub

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
does anyone have the code needed to move a file to another folder, or a
way
of doing this through save as and then delete. The folder will be picked
via
a variable.