Combine multiple workbooks into one excel workbook

**superbob** · 02-09-2010, 09:53 AM

Hi,

I'm trying to create some code which will allow me to browse through folders and combine different workbooks together. The workbooks all only have 1 worksheet and the data is in exactly the same format.

Any ideas?

**blane245** · 02-09-2010, 11:32 AM

This is pretty simple using the FileSearch object and WorkSheet.Copy method in VBA. How are you in VBA?

**superbob** · 02-10-2010, 05:36 AM

I'm using excel 2007 so I can't use filesearch.

**blane245** · 02-10-2010, 08:38 AM

Oh, I didn't know that wasn't available in 2007. Surely, there must be some means to do file searches. Do they have some other type of object to do this?