Move multiple files from multiple folders to one folder via macro

Hi,

I have multiple files in multiple folders and I want to move the files within each of the folders to one folder via a macro.
The folders are any name.

Existing folders names:
Document saved as HTML file for anyemail.com (within this folder there are multiple html files)
Document saved as HTML file for anyemail1.com (within this folder there are multiple html files)
Document saved as HTML file for anyemail2.com (within this folder there are multiple html files)

I want the macro to move the html files into another folder called s:\Documents

Can you help me with this request?

Thank you,
Ash

Same idea as renaming - requires reference to MS Scripting... If you need to keep track of the source folder, you could create new folders in the destination folder or rename the file to include the original folder name....

Please Login or Register  to view this content.

That doesn't happen for me - what does the msgbox say when you use this (it won't actually move the files, just show the first one's name and folder):

Please Login or Register  to view this content.