I'm using MS Word 2003:

I have files saved in a folder numbered structure:

OLDFILES/
001/5674.tiff
/5675.tiff
/5676.tiff

002/5677.tiff
/5678.tiff
/5679.tiff

I will receive new versions of these files but in a different folder structure, usually all in one folder but they can also arrive in various folder structures within the "NEWFILES" folder.

NEWFILES/
5674.tiff
5675.tiff
5676.tiff
5677.tiff
5678.tiff
5679.tiff

I'm looking for a routine that would search each file in the "NEWFILES" folder and it's subfolders, and using it's file name, find it's location in the "OLDFILES" folder and subfolders and copy/overwrite the old file with the new file.

Basically, I receive new versions of these files but with a different folder structure so I need to update the old files with the new ones without having to find each one and manually copy and overwrite each file by hand.

The new files will always have the same file name as the old files just different folder structure.

Any help is GREATLY appreciated!

Hi

Have you tried using the Dir function

http://vbadud.blogspot.com/2006/12/dir-function-in-vba-visual-basic.html
http://vbadud.blogspot.com/.../vba-dir-function-to-get-sub-directories.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)