Results 1 to 7 of 7

Files within Multiple SubFolders and SubFolders Within It

Threaded View

codeslizer Files within Multiple... 09-16-2013, 05:00 AM
cytop Re: Files within Multiple... 09-16-2013, 05:46 AM
codeslizer Re: Files within Multiple... 09-16-2013, 06:14 AM
cytop Re: Files within Multiple... 09-16-2013, 06:50 AM
codeslizer Re: Files within Multiple... 09-16-2013, 07:01 AM
codeslizer Re: Files within Multiple... 09-16-2013, 07:53 AM
codeslizer Re: Files within Multiple... 09-18-2013, 04:18 AM
  1. #6
    Forum Contributor codeslizer's Avatar
    Join Date
    05-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    245

    Re: Files within Multiple SubFolders and SubFolders Within It

    Hey Guys,

    I made a little research, and have found that the property actually belongs to BuiltinDocumentProperties of the workbook and can be made in use when file is open. Any ways to call use this property without opening the file..? Below code works and gets me the detail

    Sub Test()
        MsgBox Workbooks.Open("<path>\Sample.xlsx").BuiltinDocumentProperties("Last Author")
    End Sub
    Last edited by codeslizer; 09-16-2013 at 07:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] list of subfolders in folder - without files and sub-subfolders
    By MartyZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2022, 10:56 AM
  2. import multiple html files from multiple and subfolders
    By wali in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-04-2011, 04:33 PM
  3. A Way to Query,(x).Xls files in (x)subfolders
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 52
    Last Post: 08-06-2011, 04:17 AM
  4. [SOLVED] Open all files in subfolders
    By linglc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2006, 05:40 AM
  5. [SOLVED] copy subfolders, replace text in files and save files in copied subfolders
    By pieros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1