Friday 16 January 2015

Getting the path and full name using Msg Box


Option Explicit

 

Private Sub CommandButton1_Click()

 

MsgBox Workbooks("c:\one.xlsx").Path

MsgBox ActiveWorkbook.FullName

 

End Sub
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)