Hey Guys,

I'm trying to move multiple files from one directory to another. I've found in the help files that the .MoveFile method can move multiple files (as opposed the the .Move method). The thing is that they don't explain how to move multiple files (in one shot)...like do I send it an array? Can it be multidimensional? Is there a specific syntax? This is how to move one file:

[vba]Set fs = CreateObject("Scripting.FileSystemObject")
fs.MoveFile Source:="C:\SourceFolder\Test.xls", Destination:="C:\DestinationFolder\"[/vba]
So what about Test1.xls, Test2.xls, Test3.xls?????

And it also says: "This method allows moving files between volumes only if supported by the operating system." What does that mean, anyway?

Or do I just have to make a loop?? (I don't want to do that, though).

Thanks in advance