Get Data set range from closed workbook
 

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

Get Data set range from closed workbook
 

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

Get Data set range from closed workbook
 

On Jan 6, 12:14*am, 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

You could use a formula