Merging separate Excel files in one

DiyaParial · Mar 8th, 2002, 03:42 PM

I have about 8 individual Excel files (1 sheet each) and I want to merge them all in one file with 8 sheets. I need to write this is a vba macro, does anyone have any sample code that can help ?

Derek · Mar 9th, 2002, 06:54 AM

Hello DiyaParial

Not sure exactly what you mean by "merging" and why you would need vba to do this; Do formulas in these workbooks refer to each other? If not, why not just right click each sheet tab and copy the sheets to one book?

regards
Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 03:42 PM	#1
DiyaParial New Member Join Date: Mar 2002 Posts: 1	I have about 8 individual Excel files (1 sheet each) and I want to merge them all in one file with 8 sheets. I need to write this is a vba macro, does anyone have any sample code that can help ?

Mar 9th, 2002, 06:54 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hello DiyaParial Not sure exactly what you mean by "merging" and why you would need vba to do this; Do formulas in these workbooks refer to each other? If not, why not just right click each sheet tab and copy the sheets to one book? regards Derek