Hi

Ron de Bruin has lots of code examples on his site for doing this type
of thing.
I'm sure you will find something there you can adapt.
Scroll down to the section Copy/Paste?Merge examples
http://www.rondebruin.nl/tips.htm

--
Regards

Roger Govier


"DDK" wrote in message
...
Hi everyone,

I am trying to take 20 excel files with single worksheets and import
this
into a central workbook containing all the worksheets. And know I do
not
want to cut and paste these in by opening each file one at a time to
do this.
I need to run a program to do this all at once because this will
eventually
be in excess of 60-70 excel files I need to do this with. Worksheet
name
should carry the filename (minus the .xls). I plan to import these.
Manipulate the data and then export back out to individual forecast
files. I
have the export program figured out. Import has me. Does anyone have
a VB
program that can do this?