We have a farily large SharePoint site, (>20,000 Office documents), and we are running low on disk space. I would like to write a VBA program that walks through the tree (including subsites) and deletes all the document library history files
that are over 1 year old. I can't seem to find a way to access the history files unless I open each document; opening each document would cause my program to take months to complete. Does anyone know a way to get access to the history
files using VBA without having to open the Office file whose history I want access to? The only way I've found to access this history files is to use the DocumentLibraryVersions object, but it requires that I open the file (that I know of). I have
no problem walking the file tree and I have access to SharePoint Designer 2007, Excel 2007, and Word 2007 typelibs, object models, etc.. Due to policy restrictions in my company, I cannot install development tools on my machine, so I'm stuck with VBA.
Also, I won't be allowed to create a web service; although I can access one that already exists on our server in case any come with SharePoint.
P.S., I have lots of good VBA code that I've written over the last 15 years to do all kinds of tasks with Office and SharePoint that I'm happy to share if anyone can benefit from it.&
View Complete Post