Thanks for responding. I will look into those sites.
-----Original Message-----
Application.FileDialog was added in xl2002.
John Walkenbach has a Browse for Folder at:
http://j-walk.com/ss/excel/tips/tip29.htm
Or you could use:
Application.GetSaveAsFilename
and ignore the filename.
And I would open each workbook.
Maybe you could do something with ADO, but I've never
used it.
Ole P. Erlandsen has lots of info at:
http://www.erlandsendata.no/english/vba/adodao/
It might help.
Rick wrote:
Anyone have any thoughts on how I go about this?
I need to build a recap workbook with data from several
other workbooks. The user would need to have a window
to
choose the multiple workbooks from different directories
to recap (does excel have a file window other than
getopenfilename and saveasfilename?).
The workbooks would not have a constant number of rows.
In other words I would need to get the number of rows
and
columns from each workbook prior to building the recap
workbook. Can I do this without opening each of the data
workbooks (each workbook is over 5 meg without data)?
--
Dave Peterson
.