Urgent Help Please! File combine

jefftse · May 18th, 2002, 01:17 PM

Hi everyone:

This is my first message in your site and I hope someone out there will help me please.

I have about 200 some excel files that I need to copy and paste into a one big file.

Does anyone outta know a VBA macro script to do that. I need this done asap.

HELP!!

Nimrod · May 18th, 2002, 01:56 PM

Hi Jeff Love to help if you can be a little more specific.
How many workbooks involved ?
How Many sheets in each workbook?
Is it A straight copy i.e. entire row from source to entire row in target ?

jefftse · May 18th, 2002, 03:14 PM

Hey.

Thanks for your fast reply. I finally found the utility from asap which someone already had the same problem in the pass. I already combine all the file together.

by the way, this is a GREAT site and I will definitely come back this site very often now.

thanks again.

Brian · May 18th, 2002, 11:43 PM

Thanks for the info. The site is:

http://www.asap-utilities.com/index.php?page=/p_ln2.php

May 18th, 2002, 01:56 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Hi Jeff Love to help if you can be a little more specific. How many workbooks involved ? How Many sheets in each workbook? Is it A straight copy i.e. entire row from source to entire row in target ? __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

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

May 18th, 2002, 01:17 PM	#1
jefftse New Member Join Date: May 2002 Posts: 2	Hi everyone: This is my first message in your site and I hope someone out there will help me please. I have about 200 some excel files that I need to copy and paste into a one big file. Does anyone outta know a VBA macro script to do that. I need this done asap. HELP!!

May 18th, 2002, 03:14 PM	#3
jefftse New Member Join Date: May 2002 Posts: 2	Hey. Thanks for your fast reply. I finally found the utility from asap which someone already had the same problem in the pass. I already combine all the file together. by the way, this is a GREAT site and I will definitely come back this site very often now. thanks again.

May 18th, 2002, 11:43 PM	#4
Brian Board Regular Join Date: Apr 2002 Posts: 113	Thanks for the info. The site is: http://www.asap-utilities.com/index.php?page=/p_ln2.php