• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel VBA - Checking Out and Checking In files In SharePoint Document Library

Status
Not open for further replies.
I have number of files with OLAP Pivots in SharePoint Document Library. All I am required to do is to refresh these files on a weekly basis and save them at the same location. However, this whole process is very very time consuming partially due to size of the files and partially due to poor performance of SharePoint 2007. I am looking for programs/scrips which will help me: 1. Check Out the file>> 2. Refresh the File>> 3. Save the File in the Doc Library> 4. Check In the file.


I have tried Workbooks.CanCheckOut and Workbooks.CheckOut classes in Excel but they do not actually check the file out but rather prompts me to check the file out manually in the security notification area (Excel 2007).


Any ideas on to how to automate my work?
 
Good luck with that.


I've literally wasted hours trying to get sharepoint to do very simple things. It should be deleted, obsoleted, and those that use it should be given a special place in heaven. It is a bastardization.


Email me privately if you want my real opinion.


:)


what version of sharepoint?
 
@Hui: I have not tried recording but I believe 2007 recorder is not as good as 2003, but I will surely give it a try.


@Dan: Funny. Well this is something because of which even I have been scratching my head for months. I am using SharePoint 2007 and someone just told me its possible with .Net using SharePoint Services. I dont know much about SharePoing services or .net. So I was trying my luck looking for simpler way.


@ Chandoo: I didnt get any email alters for the above 2 posts. Is this how it is or have I missed something? (Thanks for your special consideration as this my first post)
 
Akash

I'm not a sharepoint person

Have you asked on any of the Sharepoint Forums ?
 
Akash

I'm not a sharepoint person

Have you asked on any of the Sharepoint Forums ?


I have number of files with OLAP Pivots in SharePoint Document Library. All I am required to do is to refresh these files on a weekly basis and save them at the same location. However, this whole process is very very time consuming partially due to size of the files and partially due to poor performance of SharePoint 2007. I am looking for programs/scrips which will help me: 1. Check Out the file>> 2. Refresh the File>> 3. Save the File in the Doc Library> 4. Check In the file.


I have tried Workbooks.CanCheckOut and Workbooks.CheckOut classes in Excel but they do not actually check the file out but rather prompts me to check the file out manually in the security notification area (Excel 2007).


Any ideas on to how to automate my work?




Workbooks.CheckOut "https://url.com"
 
Status
Not open for further replies.
Back
Top