.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Managing Document Library files using Offce 2007 VBA

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :SharePoint

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

More Related Resource Links

Sharepoint 2007 delay in files are not showing up in document library


When saving a file from ie. an email attachment into a sharepoint document library the files show up in explorer view of the document library but there is about a 20 minutes delay before they show up in the default view of the document library.  This is quite frustrating as because you can not see it there the users try to save as again. 

This seems to work correctly in our test sharepoint environment.  Does anyone have any ideas as where to start looking.


Unable to open pdf from document library MOSS 2007


When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.



When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open


When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.


Reg File Upload control to upload files from document library


In Field Upload control if we click browse button it allow us to search file in our hard disk but now as per my requirement as soon as user clicks ‘Browse’ button it should point to the document libraries and their files in site.Let me know how could i achieve this?

Thanks & Regards,


overwrite the files in document library from Explorer View ?

Hi Everyone, Suppose I have a document library which can be opened using the explorer view, what happened if someone uploads to this library by drag n drop into the library with same filename? What would be the final story of the file which is overwritten through drag n drop from Explorer view ? Thanks./* Infrastructure Support Engineer */

Indexing Document library which contains .RTF files

Hi All, I've just craeted a document library objects in my SharePoint site and then i imported several hundreds .RTF files into it, how and when can i perform search and compare of this files against each other ? Does MOSS 2007 SP2 Enterprise supports indexing .rtf files ? Thanks, AWT/* Infrastructure Support Engineer */

Moving files from one document library to another problem.

Hi, I have a strange problem with trying to move a number of files progammatically from one document library to another. I have a workflow running in sharepoint, which throughout the progress of the workflow, updates a word document stored in a document library, titled "CR".  Within the CR library there may also be a folder title "CR X" where x is the number of the document.  This folder contains any files which have been attached to the CR document.  I.E, excel files, pictures etc. When the workflow completes, the document should be moved to another document library called "Archived" which has a folder named after the year, i.e 2010, which inside that, contains a folder called the name of the document.  All the attached documents should also be moved to this folder. So for example, a document structure could be parentweb\parentsite\CR\CR 2.doc parentweb\parentsite\CR\CR 2\image.jpg parentweb\parentsite\CR\CR 2\image2.jpg Should, when the workflow completes end up looking like: parentweb\parentsite\Archived\2010\CR 2\CR 2.doc parentweb\parentsite\Archived\2010\CR 2\image.jpg parentweb\parentsite\Archived\2010\CR 2\image2.jpg. I have got the first part working fine, where the document is moved to the archive directory.  But I cannot move all the attachment files.  The loop I have to get the files and move them will wo

Converting Word Documents library to PDF document library in SharePoint Server 2007

My project requires me to create an event reciever such that when a word file is added to one library the same content pdf file should be added to other library also when a word file is updated,edited or checked in the respective pdf file in other document library should be replaced by a new pdf file with the edited word content . Can we do this in Sharepoint 2007 I have seen this can be done in Sharepoint 2010 http://msdn.microsoft.com/en-us/library/ff181518.aspx

Document library hiding pdf files' tool bar

Hi all, I have a requirement that the Sharepoint pdf documents should have the toolbar hidden in order to prohibit users from downloading and printing the file. The only way I can do this is to create a content editor web part, using HTML to open the pdf file and add '#toolbar=0' after the pdf file name. I am wondering if I can also add '#toolbar=0' to the Sharepoint document library's pdf files? Thanks!

Customizing Send To Other Location Functionality for a document library item in Moss 2007

Hi All i have a requirment to customize the Send To Other Location funtionality. while using OOTB Send to Other Location option for a document library item we have  selection like Prompt the author to send out updates when the document is checked in? <input id="ctl00_PlaceHolderMain_ctl01_ctl01_RadShouldUpdateYes" name="ctl00$PlaceHolderMain$ctl01$ctl01$ShouldUpdate" type="radio" value="RadShouldUpdateYes" /><label for="ctl00_PlaceHolderMain_ctl01_ctl01_RadShouldUpdateYes">Yes</label> <input id="ctl00_PlaceHolderMain_ctl01_ctl01_RadShouldUpdateNo" checked="checked" name="ctl00$PlaceHolderMain$ctl01$ctl01$ShouldUpdate" type="radio" value="RadShouldUpdateNo" /><label for="ctl00_PlaceHolderMain_ctl01_ctl01_RadShouldUpdateNo">No</label> how we can set this option in my custom coding based on the user selection. i am not able to understand the functionality of the above option. can any one please explain the above option and let me know how to set this option programmtically in my custom code.   Thanks in Advance  muthu

Opening office Documents in MOSS 2007 document Library.... You get a prompt to login...

*Sigh* i know i'm not the only one who has experienced this.   You have a Moss 2007 farm on your Server... yet you have employees and users who use Office 2003 products (word, excel, power point) Everything is installed correctly you yourself use office 2007. but don't post office 2007 docs.. just open the docs that people already post (2003 stuff) Computer Environment si am using....It does this in both Environments1st one Windows Vista Ultimate Updated Service Packs Office 2007 All update Serice Packs Internet explorer 7.0 2nd Environment Windows XP all updated Service Packs Office 2007 All updated Service Packs Windows Internet Explorer 7.0 Server Environment Moss 2007 with SP1 installed Microsoft 2003 Server No matter what happens.... when i try to open up a word documents or excel or anything.. when using office 2007..... it ask me for a login...I believe there was an article about correcting something in the registry or something.. can someone give me detail bulleted / bold instructions... this has been bothering me for a while.

Document Library Filtered by Document Type in Sharepoint 2007

Dear Friends, I have a doucment library where we uploade the word document, but when I uploade the document that time it show the all file type, Can I filtered those file type in sharepoint 2007, Its very urgent for me.  

Sharepoint 2007 - 80GB Documents in 1 document library

Hi, My customer wants 'customer docs' in SharePoint. It is now stored on several disks and wants to move it to SharePoint 2007(!). It needs to go into a folder structure.....I'm now investigating the information that needs to move to SharePoint and it turns out a quick scan resulted in 210.000 documents with a total volume of 80GB. Off course this is raw data and thus containing archives, zips, access databases and a lost movie and the like (just like any normal network drive :-)). When I look at the limits and best practices: no folder should contain more then 2.000 items (OK) no doc lib should contain more then 2.000.000 items (more then OK) no file should be larger then 2GB (OK - we set it to a max of 150MB) It is all fine but my concern is the shear size of the total load. Let's say they don't migrate 80GB but 30-50GB. My Question: can a single MOSS 2007 document library hold this kind of documents and total size? What does this mean for overall performance, backup, search indexing, crawling etc etc?  Thnx for any tips!

Querystring to determine what Document Library Folder's files to list?

First of all, any webpart that alllows you to list documents in a particular folder of a Document library? Second, possible to pass what folder to list via a query string to  that webpart ? Thanks.

Migrate/Move Document Library from Sharepoint 2007 to Sharepoint 2010

Hi, I have a customer that is setting up a new SPS 2010 environment. They have a Sharepint 2007 environment with one document library containing only PDF files. They will not need any metadata on these documents, but would like it to be moved to the new SPS 2010 environment only to be used for history and free text search. Is there an easy way to accomplish this?   Regards Christian GrannesChristianLLoyd

Office 2007 Documents Open in Read-Only when Opening them from a WSS 2.0 Document Library

Hi, When any of our Windows 7 Pro computers that run Office 2007 Pro attempt to open a Word document that resides in a WSS 2.0 document library by using the drop down menu and selecting "Edit with MS Word", the documents open in read-only.  Our work-around is to save the document locally, modify it, and then save it back to the document library. We have some Windows XP and Vista systems that run Office 2007 and they are fine and can simply edit the document and save it.  We also have a handful of pc's that run Office 2003 and they are not having any issues either. Things I've tried: Office 2007 Repair - no luck Office Reinstall - no luck Some registry mod HKCU\Software\Microsoft\Office\12\Internet\OpenDocumentReadWrite=1 (noted on a MSKB article) - no luck and after re-reading the article it clearly states that this will not address content hosted on WSS or SPS sites Clearing IE temp files, resttting IE to defaults - no luck Once again, this only seems to happen to Win7Pro pc's that run Office 2007.  Honestly, I can't tell if IE8 has anything to do with this. Any thoughts or help would be extrememly appreciated. Thanks, Mike

Windows 7, Office 2007, and WSS 3.0: Losing file path when saving to Document Library.

A client of ours recently purchased 5 desktops with Windows 7 and Office 2007.  They use Sharepoint to share all documents for their company. The computers that have Windows XP on them can browse the Sharepoint site, open documents (read only or edit), and chose to Save or Save As.  A new window pops open with their current file path of the Sharepoint Document Library so they can save the file in the same folder they opened it from.  I have tested this with Office 2003 and 2007 (Word and Excel) on XP and it always works. The 5 new desktops running Windows 7 cannot do this.  When a user opens a document by browsing to it from Internet Explorer and chooses to Save or Save As, they are kicked back to their last successful save point (usually My Documents or Desktop). The current work around is mapping a drive to the root Document Library directory and having them traverse through the folders to save it back in the original location. I've tried changing the Check Out save settings in Word 2007 and Excel 2007 to edit directly on the server, but I run into the same problem.  I've also made sure that IE sees the site as a Local Intranet site and Protected Mode is off. Any help would be appreciated.  Thanks in advance.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend