Forum Discussion
How to read file properties. Old method stopped working after update.
Hi, my workbooks suddenly stopped working after an Windows/Excel update. I used Excel VBA to read the file properties of files in a folder, without opening them. Now the same code is just retur...
Hi,
I am seeing the same problem with all but the initial properties (circa 6) returning as blank.
It appears very machine build specific as the code is running on some machines and not on others.
Did you ever get a solution for this Eirik?
Alternatively, can anyone suggest the quickest alternative solution for returning the File properties from a remote shared server space?
hi, I haven't found a solution yet. It seems like a pretty serious error by MS.
My only workaround is for the code to open each workbook and use:
For Each fil In oFolder.Files
Set wb = Workbooks.Open(file.path)
debug.print wb.BuiltinDocumentProperties("comments")
My only workaround is for the code to open each workbook and use:
For Each fil In oFolder.Files
Set wb = Workbooks.Open(file.path)
debug.print wb.BuiltinDocumentProperties("comments")