Combining Worbooks With Identical Names

[Saighead]

Hi,

I have two folders containing different versions of the same workbooks. The names of the files are identical. I need a script that would identify workbooks with the same name and copy Worksheet 1 of Workbook 1 AFTER Worksheet 1 of Workbook 2. Can this be done? The folders have hundreds of files and it would take me a week to do this manually.

Thanks in advance.

Also posted here

 

[Norie]

You can't open 2 workbooks with the same name at the same time.

You'll need code to rename the workbooks in one of the folders.

 

[Saighead]

You can't open 2 workbooks with the same name at the same time.

You'll need code to rename the workbooks in one of the folders.

Piece of cake. I can just batch rename files in one or both folders. Say "Name (Ver1)" for folder 1 and "Name (Ver2)" for folder 2. No code necessary. It's all the rest that is a problem...

 

[Saighead]

Got an answer on another forum. Thank you.