Workbook.Name property Archives

Learn

Excel Macro: Create a Backup of a Workbook with Current Date

This simple macro can backup your workbook with today's date as part of the file name in the Same folder. Get this VBA code now!

Learn

Excel Macro: Open All Workbooks in a Folder

Opening each workbook in a folder or directory is typically a time consuming manual process. This Excel macro takes care of that annoyance.

Workbook.Close method Application.ActiveWorkbook property Workbook.Name property Workbooks.Open method Do...Loop statement Dir function

Learn

Excel Macro: Refresh All Data Connections on Workbook Open

This Excel macro code allows you to refresh all data connections on Workbook open. Get this VBA code now!

Workbook.Name property Application.ThisWorkbook property Workbook.RefreshAll method Workbook.Open event

Docs

Workbook.Name property

Returns a String value that represents the name of the object. Syntax expression.Name expression A variable that represents a Workbook object. Examples […]

Workbook.Name property