Importing 23 Excel Datafiles to one Excel Datafile at The Click OfA Button
 

Hi,

I'm stuck in Importing 23 Excel datafiles called " Data for State1
2009.xlsx",........,"Data for State23 2009.xlsx" to a single Excel
Datafile called " Import.xlsx".All 24 datafiles are stored in asigle
folder called Excel in location C of my computer.

Kindly help me out.


Kind Regards,

siddharth

Importing 23 Excel Datafiles to one Excel Datafile at The Click Of A Button
 

Hi Sidhu

If you want it easy try
http://www.rondebruin.nl/merge.htm

See also the code links on the bottom of the page


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sidhu Khanna" wrote in message
...
Hi,

I'm stuck in Importing 23 Excel datafiles called " Data for State1
2009.xlsx",........,"Data for State23 2009.xlsx" to a single Excel
Datafile called " Import.xlsx".All 24 datafiles are stored in asigle
folder called Excel in location C of my computer.

Kindly help me out.


Kind Regards,

siddharth