FileCopy extremely slow

[Idiot]

I am trying to make a macro that copies a file per row to a folder specified by a cell in the row (and then calls a command line tool on it). I am using FileCopy to copy the file, but it is extremely slow even for only 6 rows (I need it to work with hundreds).

I think the problem is that the folders are network folders. Is there maybe another copy file function in VBA that does not block while the operation completes? I could go through all my rows and just copy the files, then go through again and run the command line tool. By the time it reaches the end of the sheet, the first file would be done copying.

[ravishankar]

Hi
Can you post the codes you are using?
Ravi

[Idiot]

I found a solution to this problem: Use VBA.Shell("xcopy ...") instead of FileCopy.