Saturday, 23 March 2013

Macro To Know Active Work Book Path and Full Name

How To Know Active Work Book Path and Full Name 
Sub WorkBook_Details()
ActivWorkbookPath = ActiveWorkbook.Path
ActiveWorkBookName = ActiveWorkbook.Name
ActWorkBookFullName = Application.ActiveWorkbook.FullName

MsgBox "ActiveWorkBookName = " & ActiveWorkBookName & vbCrLf & _
"ActivWorkbookPath = " & ActiveWorkbook.Path & vbCrLf & _
"ActWorkBookFullName =" & Application.ActiveWorkbook.FullName, vbInformation, "Work Book Details"

End Sub

Thanks.,
Tamatam

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts