Search for pdf files by date or title

i think your best off tackling in 3 steps

list everything in folder which is pdf
from list find stuff and delete ones that dont match criteria

hyperlink part is actually probably the easiest bit

Please Login or Register  to view this content.

this is the code for listing all pdf in folder
note
if for some reason pdf doesnt have "-" in it...it wont list
if it has too many "-" in there it wont work

hmm i may have over thought...though i am unsure of duplication would be an issue but
the search string can override the need to write in files

Please Login or Register  to view this content.

instr is case sensitive if that is an issue need to UPPER or LOWER everything first

See attached spreadsheet
the only thing you need to update is

Please Login or Register  to view this content.

change this to your directory

press the grey button and it should work

i added the hyperlink feature into this one as well

Please Login or Register  to view this content.

an alternative if you having with re-writing code
i can re-write it for you that it searches the folder in which the file is placed

would that be better?

Here you go
i replaced

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

now all you have to do is place this file in the folder where all the pdf are stored

confirm your PDF file structure
is it NAME - INV - Date

also Does your date have "-" as seperator? or is it something like 200515?
if it is like 20-05-2015 then i will need to re-write code

no the issue is how i constructed the break down
i only thought there was 3 "-" in the file name but based on what you have told me there is actually 5 "-"
also is [] around the date for all files as well?

having it Jul or as a plain number doesnt make a difference
thats ok ill have a look at it tomorrow

just block that section out (by putting a ' infront of it) for the time being and if everything else works fine then there is only one line to fix tomorrow

since im checking to make sure im not making another assumption
is there any chance that there will be "-" in the name or invoice field?

ie Mary-Jane brown or INV-09328 or something like that
i would need to find some other way of splitting the Name-Inv-Date if there is

Try this version

ive put a check in to determine whether INV is in the pdf filename

by counting the number of "-" in the file name
assuming without invoice there is only 3 with...there is 4

Do you mind blank that section out again and pasting all the hyperlinks in a seperate sheet so i can see what the file names are looking like
i'm only using mock data to do it ...i may be missing something in my assumption

with the search
it isn't doing exact match
it is using Instr function which does partial matches because it only search to see if the string exists in any part of the file name

so if you DH Lroberts or RobertsL DH or RoDHbLerts it would return all 3

ok i see the problem....
you have pdf's which dont have date as well as invoices that dont have invoice number

back to drawing board

and one that seems to be missing a "-"

API - 33435215529-9-14.pdf

the more i look at this the more i can see issues moving forward
its always going to hiccup when some sort of naming issues pops up

if you accidentally put a pdf in that folder that shouldnt be there

so

Please Login or Register  to view this content.

i think your best option is to put an on error resume code in there so it just skips the issue file
it wont fix it but you if you cant control the file names of the pdf this is the next best thing

also it seems case is a problem for you
so amending the search term

Please Login or Register  to view this content.

should help that
mind you if you just search for p d o r F
it will return everything because...well .pdf

how do you search for dates though?
think of how you would practically use it and i will see if i can build around it

i was referring to the syntax of how you search
you need to be specific
in the same data if you search "12-5-15" it does come up?
ps make sure it is text not date format

not a problem
the site is being unstable again

yeah just remember the code a basic text search
if you want something more fancy it needs to match how you plan to use it
just remember the more fancy you get the more likely it will break