Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2007

Tip: Looking for answers? Try searching our database.

Scripting.FileSystemObject

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ronald Dodge - 25 May 2007 22:57 GMT
Okay, I have tried using the item part of a folder collection object and a
file collection object.

I have tried it initially as late binding, then as early binding, neither
method helped.

I have tried it with using <object>.Item(#) and I have also tried
<object>(#) for both binding methods.

All 4 ways, I get the error message within the watch window, "Invalid
procedure call or argument".

I know I can use the For Each, which I have used that numerous times under
the late binding method, but I have come to a situation that I don't want
the program spending too much time searching and a pretty good majority of
the time given the nature of business practice, the code will find the
proper folder near the bottom of the folder list, so I was thinking of
having it search in reverse order via the For I = Last To First Step -1
route, but it seems as though it's not allowed.  Am I missing something
here?

Where the # is, I would have that as a valid number and even used a number
like 2 for test purposes, when there's 5 items in the list as shown in the
watch window.  In practice, there could really be more like about 200
folders in the parent folder.

Signature

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

Tom Ogilvy - 26 May 2007 01:55 GMT
The argument to ITEM for the folders collection is Key.

Debug.Print fldrs.Item("I386").Name

works returning I386.  I don't believe it accepts an index argument - only
the key value; which for folders appears to be the folder name.

Signature

Regards
Tom Ogilvy

> Okay, I have tried using the item part of a folder collection object and a
> file collection object.
[quoted text clipped - 21 lines]
> watch window.  In practice, there could really be more like about 200
> folders in the parent folder.
urkec - 26 May 2007 07:20 GMT
> I know I can use the For Each, which I have used that numerous times under
> the late binding method, but I have come to a situation that I don't want
[quoted text clipped - 9 lines]
> watch window.  In practice, there could really be more like about 200
> folders in the parent folder.

What kind of search?

Signature

urkec

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.