Hi,
I have an Excel Tool that opens several spreadsheets in several folders and adds comments in the file's properties (looping via InputWB.BuiltinDocumentProperties.Item ("Comments")).
The problem is, whenever I encounter files with Password To Open or Password To Modify. Right now, I just flag files like these, and manually put comments in them.
Can somebody suggest a workaround?, or perhaps a different approach?
I found several possibilities using a DLL (dso.dll), but I can't use or even test it since I do not have Admin Rights to my PC and can't register the said DLL.
By the way, I'm doing this as part of our IT controls, to put ID's in our Spreadsheets that have Automation.
Thanks!
I have an Excel Tool that opens several spreadsheets in several folders and adds comments in the file's properties (looping via InputWB.BuiltinDocumentProperties.Item ("Comments")).
The problem is, whenever I encounter files with Password To Open or Password To Modify. Right now, I just flag files like these, and manually put comments in them.
Can somebody suggest a workaround?, or perhaps a different approach?
I found several possibilities using a DLL (dso.dll), but I can't use or even test it since I do not have Admin Rights to my PC and can't register the said DLL.
By the way, I'm doing this as part of our IT controls, to put ID's in our Spreadsheets that have Automation.
Thanks!
