akashbest@gmail.com
New Member
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?
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?