danny tang wrote :
hi, happy new yr.

in closed workbook/active workbook, we can use usedrange.rows.count or
columns.count to determine the size of data set. However, this is not work in
closed workbook. Any ideas to determine the number of rows/cols. in this
case? thx.

br
danny

Here's a good place to start...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc