How about something like this, in pseudo code:

1. get a list of filenames using FileSystemObject
2. open each file using Application.Workbooks.Open and .Save. This
should refresh the contents.
3. copy each file to the new folder using FileCopy utility.

HTH, Jenn