Option Explicit
Private strPath As String
Private Sub ThisWorkbook_Open()
strPath = ThisWorkbook.Path
End Sub
What's the lifetime of strPath? There a reference anywhere that
explains the lifetime of objects/variables?
--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!