Name related procedures in class Workbook (Excel VBA)

This page presents procedures from class Workbook related to the theme Name: CodeName, FullName and FullNameURLEncoded

CodeName

Returns the code name for the object.

The value that you see in the cell to the right of (Name) in the Properties window is the code name of the selected object. At design time, you can change the code name of an object by changing this value. You cannot programmatically change this property at run time. The code name for an object can be used in place of an expression that returns the object. For example, if the code name for worksheet one is Sheet1, the following expressions are identical.

Dim strCodeName As String
strCodeName = ActiveWorkbook.CodeName

FullName

Returns the name of the object, including its path on disk, as a string.

Dim strFullName As String
strFullName = ActiveWorkbook.FullName

FullNameURLEncoded

Returns a String indicating the name of the object, including its path on disk, as a string.

Dim strFullNameURLEncoded As String
strFullNameURLEncoded = ActiveWorkbook.FullNameURLEncoded