OK thanks guys it will take me a while to take the above in and getting late in Australia, I will report back tomorrow.
OK thanks guys it will take me a while to take the above in and getting late in Australia, I will report back tomorrow.
Just to clarify, when I say "write" properties, this is into an Excel cell. Maybe I should use the term "read" from the point of view of the macro.
I can edit these properties through the application or if this is not possible using software such as File Metadata which is like a shell in Windows Explorer (http://filemeta.codeplex.com/). I can see the properties in Windows Explorer but for some reason, and this only applies to some file types such as XLSX and DOCX, some of the properties such as Title, Author and Subject cannot be read while others such as Size can be read. For PDF everything can be read.
Posting Permissions
Reply With Quote