I have a template workbook that is copied and renamed to be unique for the project and date the report is created for. The routines in the workbook modules need the name of the primary workbook as a global variable so the routines can always get back to origination point that calls each routine.
Is there a simple way to declare and define a global variable that is the workbook name so all modules and routines in the workbook always know the workbook name.