Moving a file from a folder to another via vba

[Enkay62]

Hi.
I'm trying to write a sub to move a file from folder1 to folder2 (e.g.).
I tested this

File.Move "C:\Folder1\Myfile.xls" , "C:\Folder2\Myfile.xls"

but it doesn't work.

Where am I wrong?

(Moreover: can I move a shortcut file too?)

Thank you in advance for your suggestions.

Nick

 

[TPetersonFlorida]

you can do this very easily w/ the filesystemobject:

Dim fs
Set fs = CreateObject("Scripting.FileSystemObject&quot
fs.movefile [sourcefile], [destinationfile]
Set fs = Nothing