Tags Tags

Get Data set range from closed workbook

January 06th, 2012 - 01:14 am ET by danny tang | Report spam
Help Create a new topic
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
email Follow the discussionReplies 2 repliesReplies Make a reply

Replies

#1 GS
January 06th, 2012 - 05:54 am ET | Report spam
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/D...amming.zip

Garry

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

Similar topics

Make your own search :