Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up

    I'm not sure whether this question belongs in this forum or the server forum.

    We have 200+ Excel files in a SharePoint document library. This library is hosted by a third party, not our internal servers.

    We need to make some identical modifications to all of the files.

    I have the VBA code that can loop through the files, make the changes, and save the file.

    The problem is that our files have to be 'checked out' before changes can be made.

    [attachment=90259:CheckOut.png]


    Is there any way to automate the check out/in with VBA?

    I'm using Excel 2007.
    Attached Images Attached Images

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Quote Originally Posted by zymurgy View Post
    I have the VBA code that can loop through the files, make the changes, and save the file.

    The problem is that our files have to be 'checked out' before changes can be made.
    I don't know anything about SharePoint, but I found the following article for Office 2003. Scroll down to or search for "Using Check Out and Check In".

    Using Microsoft Windows SharePoint Services with the Microsoft Office System

    Is it of any use in Office 2007?

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the link.

    I'll have to try it when I go in on Monday.

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The code in the Using Check Out and Check In section works with Excel 2007. Yay!

    One tip if you are using a variable to hold the file name: For Check Out I had to use the full path to the SharePoint file; For Check In only use the file name as shown in the title bar when the file is open.

    This is probably explained in the Note at the end of the section, but I didn't catch it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •