Visual Basic Folder Search

[Ca1icoJack]

I have files scattered throughout my harddrive and network. The path to them is obviously different, but the final folder and contents are labelled identically. How could I search my entire network for such folders?

I tried using a wildcard to specify all locations:

"\*\ & MyFolder & "\Inspect\"

I want to be able to chose the variable MyFolder and copy certain files from "Inspect" into another centralised folder.

How would I do this?

 

[vb5prgrmr]

Could be wrong...but I believe you are going to have to make a list of the root drives (and network drives) and then enumerate through that list with your search criteria. However, you should be able to build that list dynamically in code (as some machines may be turned off or unavailable right at that moment).

Good Luck

 

[fumei]

How exactly are you trying to do this? Using Application.FileSearch? Some other scripting method?

Are you even doing this by code? If so, you may be better off posting to a coding forum.

vb5prgrmr is right though. You are most likely going to have to enumerate through the folders from each root.

faq219-2884

Gerry
My paintings and sculpture

 

[SkipVought]

Hi,

Please post VBA questions in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

We do not even know if it is VBA.

Heck, we do not even know if this is a coding question, although admitedly it seems like one.

faq219-2884

Gerry
My paintings and sculpture

 

[SkipVought]

I dunno, the title seemed like a tiny hint to me. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

Ooops...yes, it is a coding question..duh..."Visual Basic" may be a clue.

Since the OP is not responding, I sugest we fogedaboutit.

faq219-2884

Gerry
My paintings and sculpture

 

[SkipVought]

Hey, I grew up in the Phillie area, and I know all about "fugedaboudit."

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

Ooops. My spelling mistake. It is decidely a "u" and a "d", as in fugedaboudit.





I put it into my AutoCorrect in Word. Thanks Skip.

faq219-2884

Gerry
My paintings and sculpture

 

[SkipVought]

Git er dun!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}