You can define a "Public" variable in the definitions section above the subs in
a module. It
is then available to all subs and functions.

Like this
Public strName As String

Sub DoWhatever()
...
strName = YourCodeHere
...
End Sub