ahuimanu

Chapter 8 Problem 7

Jul 12th, 2015
272
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Option Explicit
  2.  
  3. Sub WbkAttributes()
  4.     MsgBox "The name of this workbook is " & ThisWorkbook.Name & ", and it was " _
  5.         & "created by " & Application.UserName & ".", vbInformation
  6.    
  7.     ' The following statement has almost the same effect. I found it by searching through
  8.    ' the Object Browser.
  9.    MsgBox "The name of this workbook is " & ThisWorkbook.Name & ", and it was " _
  10.         & "created by " & ThisWorkbook.BuiltinDocumentProperties("Author") & ".", _
  11.         vbInformation
  12. End Sub
Advertisement
Add Comment
Please, Sign In to add comment