Trim file name to remove extension

[templeowls]

I'm using 'Application.CurrentProject.Name' in VBA to populate my DB's file name, but it's (understandingly) including the file's extension (.accdb).



Any suggestions on code to remove that? (Basically remove everything after the period, including the period itself)

[xps35]

Combine the InStrRev function (find the ".") and the Left function (part in front of the ".") in one expression.

[xps35]

Or use the Replace function to replace ".accdb" with "".

[templeowls]

Combine the InStrRev function (find the ".") and the Left function (part in front of the ".") in one expression.

Gotcha. So I tried the below but am getting a 'external name not defined error on the 'application.currentproject.name'. Any suggestions?

Left([Application.CurrentProject.Name], InStrRev([Application.CurrentProject.Name], ".") - 1)

[templeowls]

Nvm. Just needed to get rid of the brackets. Thanks!

[moke123]

nevermind deleted.