Simeon
New Member
Hi all,
how can i use VBA to shorten all filenames in a folder?
My files all start with "ABC001" and i only need these first six characters of the filename (e. g. full filename ABC001 Holidays)
The Makro need to check if the file begins with "A" and if yes, it should shorten the filename and leave only the first six characters in the name: ABC001
Thanks in advance.
Simeon
how can i use VBA to shorten all filenames in a folder?
My files all start with "ABC001" and i only need these first six characters of the filename (e. g. full filename ABC001 Holidays)
The Makro need to check if the file begins with "A" and if yes, it should shorten the filename and leave only the first six characters in the name: ABC001
Thanks in advance.
Simeon