Get Data set range from closed workbook

[danny tang]

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

 

[GS]

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/DatabaseProgramming.zip

 

[Don Guillett]

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 inclosed workbook. Any ideas to determine the number of rows/cols. in this case? thx.

br
danny

You could use a formula