| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create folders from list vb/macro? | Excel Discussion (Misc queries) | |||
| macro to list folders only, not files | Excel Worksheet Functions | |||
| VBA Macro - Loop through folder and move files to other folders | Excel Programming | |||
| loop folders macro - Sorry for duplicate posts | Excel Discussion (Misc queries) | |||
| Create folders on a shared drive with a macro | Excel Programming | |||
Hybrid Mode
