Workbook name as variable to another workbook

N

Nigel

Hi,

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.

Regards,

nigel
 
D

Dave Peterson

Option Explicit
Dim myWkbkName As String
Sub runmefirst()
myWkbkName = ThisWorkbook.Name
End Sub
Sub runmesecond()
MsgBox myWkbkName
End Sub

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:
Public myWkbkName As String
 
Top