Hi all,
Desperate for some help, been scouring the internet for ages and just cannot find what I need.
I have basically created a document in excel which provides our customer with all the information they need along with a .jpg image of a signature.
The images are saved in folders which are dependant on when the signature was taken, for that reason I have several variables.
The file path which always remains the same is "\\ENTAP08\PDA Attachment Storage\PROD\"
Then follows the year folder which is in A1
Then the date folder which is A2
Then the known part of the filename which is A3
and the rest is unknown (time stamped in seconds, time delay for the upload to our network unfortunately makes it impossible for us to know the exact time)
So what I will end up with is the following: "\\ENTAP08\PDA Attachment Storage\PROD\2017\20170320\task_id2690223"
Whereas the full file name may be: "\\ENTAP08\PDA Attachment Storage\PROD\2017\20170320\task_id2690223__customer_sign20170326112329.jpg"
I have pulled together the below code but cannot get it to work. I would greatly appreciate any advice which can be offered.
I managed to get it to work if I removed the wildcard and manually put the filename (as a test) and it worked fine, just need it to account for the wildcard. Im either very close or very far away
Many thanks
Dan
Bookmarks