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

No comments:

Post a Comment