Typically I would just run through the help menu for this, but our VBA
program at work doesn't have it, so hopefully this is a simple enough
question:

Is there a way to set a variable as the name of the currently open
workbook/file?