Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Option Explicit
- Sub WbkAttributes()
- MsgBox "The name of this workbook is " & ThisWorkbook.Name & ", and it was " _
- & "created by " & Application.UserName & ".", vbInformation
- ' The following statement has almost the same effect. I found it by searching through
- ' the Object Browser.
- MsgBox "The name of this workbook is " & ThisWorkbook.Name & ", and it was " _
- & "created by " & ThisWorkbook.BuiltinDocumentProperties("Author") & ".", _
- vbInformation
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment