Hello Forum Folks

I'm looking for some VBA help please as I'm a relative newcomer to the world of coding! Can anyone help with the following problem - I need to extract all of the metadata from a number of different file types (they could be .doc, .xls, .pdf, .gif...to be honest any file type might be included), and for the results of this extraction to be tabulated in Excel. I then need to have the ability to update, amend or delete this metadata in the Excel table, and for the results of this editing to appear in the metadata of said files.

Can this be done?

Any help or advice is very much appreciated

Kind regards
Kenny