Dim myWkbkName As String
myWkbkName = ThisWorkbook.Name
If you execute runmefirst first, then runmesecond, you'll see that myWkbkname is
available in the second.
If you need to put the routines in different modules, declare myWkbkName as
Public myWkbkName As String
> Can you save a specific workbook name as a variable, to be used in a
> different macro? i need the variable to be saved and available to return to
> the specific workbook open if i have a lot of books open to complete the task.