Renaming file extensions

[sparx]

Hi all, I am having trouble trying to get VBA to change the file extension if the file extension is found to be capital letters.

I have folders containing Adobe pdf files, most are .pdf which my code can see but any remaining .PDF files, my code wont see.

I have attached the code below and can list all the files which are capital extensions, the trouble is trying to get those back as non capitals.

Please Login or Register  to view this content.

Any help would be appreciated.

[Norie]

Try putting the file extension in upper case in the If statement.

Please Login or Register  to view this content.

[sparx]

Hi Norie,

Thanks for your reply, I tried your advice but it wasn't that line I am having the issue with, its this one.

Please Login or Register  to view this content.

I'm trying to rename the extension i.e: C:\Test.PDF to C:\Test.pdf

The code finds the instances where the files have capital extension letters without issue but when it finds them I want to rename the file extension from capital extension to lower case.

Hopefully this makes sense.

Alan

[sparx]

SOLVED

Here is the code I used to re-write the file extension if its found to be capital letters.

Please Login or Register  to view this content.

[Norie]

Glad you got it sorted.

Just curious though, why do you want to change the case of the file extensions?

I always thought Windows was kind of case insensitive when it came to file extensions anyway.

[sparx]

Windows does open pdf and PDF as normal and with Adobe, my file is shared between many users across a VPN and imports all the contents of a folder into a spread sheet to compare files, all the users can dump their files which are then added to the database.
To only import specific files, you can toggle which files by extension you are interested in, in my case its pdf.
When some users add their files, if they are PDF my program wont add them so wanted a way to rename PDF to pdf automatically.

Just been using the macro across a network to change file extensions on another machine or server and have altered the code, it also skips files which may be open by network users too.

If anybody is interested in renaming file extensions from uppercase to lowercase, this code works great.

Please Login or Register  to view this content.