Properties information
 

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

Properties information
 

Hi Sabram

Look in the VBA help for
ActiveWorkbook.BuiltinDocumentProperties


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sabram" wrote in message ...
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