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)?

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

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

.