can macro parse multiple excel files

macroNubee · Apr 10th, 2002, 11:14 AM

Hi, I wanted to know if it was possible to open up all the excel files within a certain folder and get data from certain columns within each of those files and place that data into one excel file. Assuming you would not know the names of the files within that folder.

Someone posted a similar question a couple of days ago but didn't get any reply.

Thanks

AJ · Apr 10th, 2002, 11:17 AM

Is this of any help...

http://www.mrexcel.com/board/viewtop...c=1428&forum=2

macroNubee · Apr 10th, 2002, 11:38 AM

AJ, thanks alot. I think it's exactly what I am looking for. I haven't tried it yet to see if it would work for me, but it seems very promising. Thanks again.

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

Apr 10th, 2002, 11:14 AM	#1
macroNubee New Member Join Date: Apr 2002 Posts: 5	Hi, I wanted to know if it was possible to open up all the excel files within a certain folder and get data from certain columns within each of those files and place that data into one excel file. Assuming you would not know the names of the files within that folder. Someone posted a similar question a couple of days ago but didn't get any reply. Thanks

Apr 10th, 2002, 11:17 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Is this of any help... http://www.mrexcel.com/board/viewtop...c=1428&forum=2

Apr 10th, 2002, 11:38 AM	#3
macroNubee New Member Join Date: Apr 2002 Posts: 5	AJ, thanks alot. I think it's exactly what I am looking for. I haven't tried it yet to see if it would work for me, but it seems very promising. Thanks again.