Posted to microsoft.public.excel.programming

igneramos[_3_] igneramos[_3_] is offline

external usenet poster

Posts: 1

Bad QueryTable Row Count

Is there a way to get the record count from a query attached to a query
table other than to look at querytable.resultrange.rows.count?

the reason I ask is because if the query returns 0 records,
querytable.resultrange.rows.count returns a value of 3. Obviously not
correct. Doesn't matter if the QueryTable is set to display field
names, either.

---
Message posted from http://www.ExcelForum.com/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Webquery [querytable] long url	LightShow	Excel Discussion (Misc queries)	5	May 21st 07 11:09 PM
QueryTable Field Name formatting	igneramos	Excel Programming	0	January 21st 04 04:09 PM
Querytable	Ben.c	Excel Programming	4	December 3rd 03 09:11 AM
Using VBA Copy/Paste and QueryTable	Hudel H	Excel Programming	0	November 17th 03 04:41 PM
MS QUERY w/out querytable	No Name	Excel Programming	1	October 24th 03 03:55 PM

All times are GMT +1. The time now is 08:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us