Sunday, May 9, 2021
Home Tags Extract

Tag: 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.