Can anyone tell me how to access the properties information using VBA? I
want to be able to get the title, Author and comments and place from
certaion files in a directory and list them in a spreadsheet.

Thanks in advance

Sabram