Posted to microsoft.public.excel.programming

danny tang danny tang is offline

external usenet poster

Posts: 12

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy range to closed workbook	Wendy	Excel Programming	6	April 11th 08 04:58 PM
Workbook named range not seen by ADO when workbook closed	Tim Lund[_2_]	Excel Programming	2	March 16th 07 08:59 AM
How to Delete a Range in Closed Workbook	Resant	Excel Programming	1	March 9th 06 02:53 AM
How to copy a range to a closed workbook	max	Excel Programming	1	July 16th 04 11:13 AM
Searching a range in Closed Workbook	TroyH[_3_]	Excel Programming	5	April 9th 04 02:21 PM

All times are GMT +1. The time now is 02:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us