macro & folders
 

Hi,
I have got a list(thousands) products that I need to look up from thousand
separate folders located in a different drive e.g P/drive. For example I need
to find whether on not product items l41 or m42 are in the folders. So I need
a macro that tells me whether the product item Im looking for is in the
folders rather than manually search.
Thanks, Mac

macro & folders
 

What does a "product" look like ? Is it an Excel file or what ?

Tim


"Mac123" wrote in message
...
Hi,
I have got a list(thousands) products that I need to look up from thousand
separate folders located in a different drive e.g P/drive. For example I
need
to find whether on not product items l41 or m42 are in the folders. So I
need
a macro that tells me whether the product item I'm looking for is in the
folders rather than manually search.
Thanks, Mac

macro & folders
 

Yes, it is excel file.

"Tim Williams" wrote:

What does a "product" look like ? Is it an Excel file or what ?

Tim


"Mac123" wrote in message
...
Hi,
I have got a list(thousands) products that I need to look up from thousand
separate folders located in a different drive e.g P/drive. For example I
need
to find whether on not product items l41 or m42 are in the folders. So I
need
a macro that tells me whether the product item I'm looking for is in the
folders rather than manually search.
Thanks, Mac

macro & folders
 

Does the filename *exactly* match the product name ?
Are the file just randomly distributed in the 1000 folders, or is there some
system ?

Tim

"Mac123" wrote in message
...

Yes, it is excel file.

"Tim Williams" wrote:

What does a "product" look like ? Is it an Excel file or what ?

Tim


"Mac123" wrote in message
...
Hi,
I have got a list(thousands) products that I need to look up from
thousand
separate folders located in a different drive e.g P/drive. For example
I
need
to find whether on not product items l41 or m42 are in the folders. So
I
need
a macro that tells me whether the product item I'm looking for is in
the
folders rather than manually search.
Thanks, Mac

macro & folders
 

Hi,
Yes it does exactly match and they are randomly distributed in the 1000s
folders.

"Tim Williams" wrote:

Does the filename *exactly* match the product name ?
Are the file just randomly distributed in the 1000 folders, or is there some
system ?

Tim

"Mac123" wrote in message
...

Yes, it is excel file.

"Tim Williams" wrote:

What does a "product" look like ? Is it an Excel file or what ?

Tim


"Mac123" wrote in message
...
Hi,
I have got a list(thousands) products that I need to look up from
thousand
separate folders located in a different drive e.g P/drive. For example
I
need
to find whether on not product items l41 or m42 are in the folders. So
I
need
a macro that tells me whether the product item I'm looking for is in
the
folders rather than manually search.
Thanks, Mac