Get Data set range from closed workbook

D

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
 
D

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
Click to expand...

You could use a formula
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula from closed workbook? 2
Get data from closed workbook for use in a variable (no copying) 3
Eport Excel data to closed Excel Workbook 4
Macro for Retrieving data from closed workbook with date in title 2
Get column name and data type from closed workbook 5
Copy data from Closed Workbook 3
Copy, paste to active workbook? 1
List sheet names in "pop-up" box for users to select 1

Top