PDA

View Full Version : Excel VBA - Check excel file names and change if necessary



LuisG
02-23-2018, 08:47 AM
Hello everyone!

I receive a lot of files that are not with the name that I want. I want the files have a specific way like DD.MM.YYYY_Plannumber
And my question is if is possible with excel vba to check if the name of the file is correct and if is not I want to give me the possibility to change automatically to that form.

Every help is good,Thanks,
Luis

SamT
02-23-2018, 01:42 PM
It would help to know all the possible name variations you can encounter in this effort.

Paul_Hossler
02-23-2018, 02:34 PM
I want the files have a specific way like DD.MM.YYYY_Plannumber


I'd suggest YYYY-MM-DD_***xx so that you can sort chronologically, and the 'dot' doesn't get mixed up with the extension

What determines the 'date' you use? The day you received it, the day it was sent, the day it was prepared, last updated, etc.

Also, where does 'Plannumber' come from, and what does it look like: always the same number of digits with leading 0's, or text, or both, or just a number of varying length, etc.??