Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    5

    Unanswered: Fetch Author of Directory File

    Hello Everyone:

    I've found some boiler plate VBA script that creates a list of all .xls files in a given directory. Also, in the loop, when an .xls file is found, the loop fetches:

    • File Name
    • Date Last Modified


    But, I can't figure out how to fetch file author.

    After a file name has been determined, the following snippet grabs Date last modified

    Code:
    LastMod = file.DateLastModified
    Available options don't include "author"

    Does anyone know how to find the author of a directory file?

    Thanks in Advance ....

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Have you searched for details of tbe excel file object
    If you havent found much another approach is to examine it whilst writing code. Providing you have fully declared the object then take advantage of intellisense and type file. And then examine the various methods and proprties discovered
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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