excel2003 move file from one directory to enother

[nodari]

I need to move file tt.xls from directory d1 to directory d2.

can you advice code in VBA?

 

[VoG]

Try like this

Name "C:\d1\tt.xls" As "C:\d2\tt.xls"

 

[jim may]

Change Red parts to your specs

Sub Move_One_File()
'You can change the path for a file
       Name "C:\SourceFolder\Test1.xls" As "C:\DestinationFolder\Test1.xls"
End Sub

 

[nodari]

Try like this

Name "C:\d1\tt.xls" As "C:\d2\tt.xls"

thank you very much.