Hi guys again,
Quick question
I know how to get the ‘last author’ details from the built in document properties of an active workbook. However, how can I do this for a ‘closed’ workbook without calling it to open?
I don’t want the closed workbook to open, also I want information to displayed in a cell
Thanks in Advance
Sloshpuppy
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Try this
PHP Code:Private Sub GetAuther()
Dim objShell As Object
Dim objFolder As Object
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.Namespace("Folder path in which your book exists")
If (Not objFolder Is Nothing) Then
Dim objFolderItem As Object
Set objFolderItem = objFolder.ParseName("Name of your book with extension")
If (Not objFolderItem Is Nothing) Then
Dim szItem As String
szItem = objFolder.GetDetailsOf(objFolderItem, 20)
End If
MsgBox szItem
Set objFolderItem = Nothing
End If
Set objFolder = Nothing
Set objShell = Nothing
End Sub
Teach me Excel VBA
Thanks Imran for providing the basis of the code, slightly tweaked to give the preferred result
Thanks again and to the remainder that supported. Great work guys !!!!
Slosh
Please Login or Register to view this content.
Glad it directed you to the solution.
Thanks for the rep+
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks