Home / Tag Archives: extract

Tag Archives: extract

Extract Workbook Name from Full Filename

If you only have a full filename reference to a workbook the following macro can be used to extract the Workbook name. This can be useful if you want to test if a Workbook is already open before attempting to open it. This is good practice and avoids receiving the standard Excel warning messages if you attempt to open a Workbook that is already open.

Read More »