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

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts