Thanks Everyone for your help will try all.

Greg
"Bob Phillips" wrote in message
...
Look at Name

sOldName = "myFile.xls"
sNewName = "c:\some other dir\its subdir\myNwFile.xls"
Name sOldName As sNewName

It won't create the directories if they don't exist so you can just do
that
like so

On Error Resume Next
MkDir "c:\some other dir\its subdir"
MkDir "c:\some other dir\its subdir\myNwFile.xls"
On Error Goto 0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Greg" wrote in message
...
Hi all I am looking to use excel to move a file when necessary. i.e.

I need to move a file called darts.xls to the folder c:\games

Thanks

Greg