Accessing Parent object property is vvvvvvvveeeerry slow, how do you speed this up...

danpark

New Member

Join Date: Jul 2011

Posts: 1

27th Jul 2011

Hi,

I have a Results object I got from AdvancedSearch, but I want to access a property of the Parent of the items, for some reason this is very slow, like 2-5 seconds with 500 results...

here is the example

For i = 1 To resultscount
tempStr(i) = rsts.Item(i).Parent.FolderPath
Next

This takes way to long... if I access the Subject of the items its real fast even without SetColumns...

Any advice how to speed this up...

Dan

« For the love of God...checking if a day is a workday??!!! | Relevante Invites you for its upcoming Online Webinar on “Excel Pivot Tables” »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When is a parent object required for a property?	paul.domaskis@gmail.com	Microsoft Excel Programming	1	13th May 2009 03:27 PM
Accessing a Parent Object's Properties	RSH	Microsoft VB .NET	8	9th Mar 2007 07:02 PM
Accessing parent object...	Jose Cintron	Microsoft VC .NET	0	7th Sep 2006 09:21 PM
Accessing child object property from parent object	João Rezende	Microsoft C# .NET	0	31st Jul 2006 04:01 PM
Accessing a property in a webcontrol from parent page	spmm#	Microsoft ASP .NET	3	26th Oct 2004 04:08 PM