Hello.
I wrote a Excel Macro which writes Names of Files from a SharePoint Library in an Excel Sheet.
Also some of the Document Properties are written in the sheet, but reading them needs quite a long time, so the macro is working for 15 minutes or so if the library consists of 200 files.
The code where i read the properties is as follows:
I figured out that the line "Set objFile = GetObject(strFilename)" is the one who needs this long time to execute.
Is there a possibility to get this running faster?
Thanks for any suggestions.
Bookmarks