Loop Search for PDF file in folder

**ANDREWA** · 10-01-2012, 08:23 AM

Hello, Im using a small macro that searches for a file in a particular folder. It searches for the Drive letter (as this can change) and uses the active cell as the file name, see below:

Please Login or Register  to view this content.

The problem I have is it turns out that there could be more than file with the same name, just numbered in order e.g. 1 to 10. Could someone please help me create a loop so it checks for the file name+number untill it finds the latest file? Or is there someway of opening the file that contains the active cell as part of the file name, but opens the newest one based on date?
Im not very good with loops, have tried but failed misserably!
All help much appreciated.
Thanks

**Chippy** · 10-01-2012, 02:18 PM

Try this:

Please Login or Register  to view this content.

As a simplification, the code uses the Like operator with the * wildcard character, to find files matching "THE_FILE *.PDF", so it will find files matching "THE_FILE 1234.PDF", "THE_FILE ABC XYZ.PDF", etc. if these exist in the folder, as well as the file names you describe: "THE_FILE 1.PDF", "THE_FILE 2.PDF", etc. Notice the space in " *.pdf" in the code; remove this space if the file names are "THE_FILE1.PDF", "THE_FILE2.PDF", etc. - your post doesn't describe the file names precisely enough.

Loop Search for PDF file in folder

LinkBack

Thread Tools

Rate This Thread

Display

Loop Search for PDF file in folder

Re: Loop Search for PDF file in folder

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions