See this for workbooks
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"need_some_help" wrote in message
...
Cool This really makes sense. As I modify this to look at multiple workbooks
(not just worksheets within the same workbook) it gets a little tricky. Any
suggestions on how to set up the array to read in multiple filenames (i.e.
some variation of this line For Each sh In Sheets(Array("Sheet1", "Sheet3")))
Thanks much

"Ken Wright" wrote:

Try he-

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"need_some_help" wrote in message
...
I'm writing a macro that opens a static folder and then copies specific
data
from all the files in that folder to manipulate. I can write the code to
open a file by specifying the exact filename. I need to learn how to open
a
file (all the files in a particular folder) one by one without knowing:

1)the filenames
2)how many files are in the folder

ahead of time. Please help