Import multiple XLS files

[RED]

Is there any way to import multiple Excel spread sheets
into one.

I have 92 separate files, each containing one sheet of
data, that I would like to import into one workbook with
92 sheets.

I know i can open each file and move the sheet from one
workbook to another but I am hoping there is an easier way.

Thanks

RED

 

[Ron de Bruin]

I have a macro example on this page Red
http://www.rondebruin.nl/tips.htm

 

[RED]

PERFECT!!!

Worked like a charm!!

Thanks for the help

RED

-----Original Message-----
I have a macro example on this page Red
http://www.rondebruin.nl/tips.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"RED" <[email protected]> wrote in

message news:[email protected]...

 

[Dennis]

Ron,

Which Macro on your site is the savior?

Thanks!

-----Original Message-----
I have a macro example on this page Red
http://www.rondebruin.nl/tips.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"RED" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

I have a macro example on this page Red

http://www.rondebruin.nl/tips.htm

Then click on this

Merge cells or sheet from all or some workbooks in a folder
http://www.rondebruin.nl/copy3.htm

 

[Dennis]

Thanks Ron for all of your time and expertise!

Dennis

-----Original Message-----

Then click on this

Merge cells or sheet from all or some workbooks in a folder
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"Dennis" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

You are welcome