get file\properties\author & organisation by vba

  • Hi and many thanks in advance!

    I have many workbooks downloaded from this web site.
    Once any of this workbooks is open.
    If I go to File\properties\"the second Tab = in spanish Resumen"

    the Autor is=OzGrid Business Applications
    ant the Organisation is= OzGrid Business Applications

    is there a way to get this by vba?

    kind of:



  • Re: get file\properties\autor & otganizastion by vba

    Hi, DROM,

    you should look for the BuiltinDocumentProperties of the workbook. ;)

    Code will add a new worksheet at the end of the workbook, change the name, amend the date and list the properties where filled in.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!