| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy range to closed workbook | Excel Programming | |||
| Workbook named range not seen by ADO when workbook closed | Excel Programming | |||
| How to Delete a Range in Closed Workbook | Excel Programming | |||
| How to copy a range to a closed workbook | Excel Programming | |||
| Searching a range in Closed Workbook | Excel Programming | |||
Linear Mode
