| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare file names to folder contents
Hi- In an Excel file I have a column of PDF file names; e.g., aaA.pdf AbC.pdf; 123.pdf. The -actual- PDFs should be in a folder on m desktop. I'd like a way to compare the list of file names to the folde contents to verify that the PDFs are in fact in my desktop folder. For each file name in the Excel doc, can a macro search for a matchin PDF file in my desktop folder and place a "yes" or "no" in the adjacen column? Thank you -- marle ----------------------------------------------------------------------- marlea's Profile: http://www.excelforum.com/member.php...fo&userid=2620 View this thread: http://www.excelforum.com/showthread.php?threadid=52289 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a list of file names within a folder in Microsoft Ex | Excel Discussion (Misc queries) | |||
| Need a macro to include file names in a folder to excel sheet | Excel Discussion (Misc queries) | |||
| Can I insert a file or folder names in Excel cells? | Excel Discussion (Misc queries) | |||
| Change names of files in a folder to match names in Excel Column | Excel Programming | |||
| Extract file names last save info from a Folder | Excel Programming | |||
![marlea[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
