If you want to get the current workbook’s full name and path without a sheet name, you can use a formula that employs several text functions to strip off the sheet name. The final result will be a text string that looks like this:
How the formula works
The CELL function is used with “filename” to get the full workbook name and path:
The result is a full path that looks like this:
The LEFT function receives the full path as text, along with the the location of square bracket “]” (minus 1) which is calculated by the find function:
With these arguments, LEFT effectively strips off the sheet name out of the path. However, the left square bracket “]” remains:
The final function, SUBSTITUTE, removes the “]” by replacing it with an empty string (“”).