How do I name a workbook using VBA?

You can name a workbook using VBA by setting its FullName property. The FullName property includes the full path and name of the workbook. If you're looking to save the workbook with a new name, you would use the SaveAs method instead. Here is how to do it:

Saving a Workbook with a Specific Name:

To save an existing workbook with a new name, use the SaveAs method:

Sub SaveWorkbookWithNewName()
  Dim newName As String
  newName = "C:\Path\to\your\new_workbook_name.xlsx"
  ThisWorkbook.SaveAs Filename:=newName
End Sub

- Replace "C:\Path\to\your\new_workbook_name.xlsx" with the desired full path and new name, including the file extension.

Renaming and Saving a Workbook:

If you want to change the workbook’s name without necessarily moving it, and you’re starting with a workbook which has never been saved or was previously saved without any specific name you should also use SaveAs:

Sub RenameAndSaveWorkbook()
  Dim newName As String
  newName = "C:\Path\to\your\new_workbook_name.xlsx"
  ThisWorkbook.SaveAs Filename:=newName
End Sub

- Again, replace "C:\Path\to\your\new_workbook_name.xlsx" with the desired full path and the new name including file extension.

Important Notes:

- If you want to save the workbook with another file format, you must specify the file format after the filename with the FileFormat parameter of the SaveAs method.

- If you try to rename a workbook using the FullName property directly without saving, you will encounter a runtime error. You must use SaveAs to effectively "rename" a workbook.

- Ensure the folder path you are providing in the Filename parameter exists or you will also get a runtime error.

By using these methods, you can effectively manage workbook naming and saving via VBA.

Learn more about this