Move multiple files with wild card name

[randell.graybill]

Hi all I was wondering if anyone knew how to move multiple files from one directory to another? The thing is the file name will always have the word rotation in it but the other part will not be the same and I can't just copy all excel files because that won't work either as not all files in the directory should be copied only those with the name Rotation in them should be moved.

Below is the code that I tried.

Please Login or Register  to view this content.

[randell.graybill]

I removed the on error resume next and it gives me the error message permission denied but I can't see why I am the owner of the folder, file and have full control over both.

[Leith Ross]

Hello Randell,

The code you have is for VB.net. I rewrote the code for Excel 2003 using VBA.

Please Login or Register  to view this content.

[randell.graybill]

thanks Leith.