I've Googled extensively and tested multiple options for more than 30 hours over the last couple of weeks. The results of my searches all LOOK reasonable, but all have failed to function properly. I have some SUSPICIONS as to why it's not working, but that doesn't lead me to solutions.
Here's my problem: I'm an "owner" of a corporate SharePoint site. (which means I have limited Admin privileges). I have (4) user workbooks (not in SharePoint) that have a total of 242 worksheets that monitor Capital Project expenditures. I've written macros to copy the worksheets to separate workbooks, save the files to the SharePoint folder, add some Named Ranges and use ContentTypeProperties to update fields in the SharePoint metadata (and views). My Summary reporting macros have been rewritten to read from the SharePoint metadata fields instead of the worksheets themselves. Once the final migration is complete, the worksheets will be maintained within SharePoint and the current (4) workbooks will be locked away and used no more. I've executed the migration macros multiple times over the last couple of months in order to prepare for final migration to the SharePoint site. The ONLY thing I'm stuck on is trying to Check-In the documents from VBA. Now, I CAN check in the document from SharePoint, but it extends the migration time to hours instead of minutes. Whenever I attempt the .CheckIN method (or .CanCheckIn), the method fails or indicates that the files cannot be checked in. Using VBA, I can delete the file from the SharePoint folder and copy (or .SaveAs) the current file to the folder. The result is that the file is "Checked Out" to me. (so it SEEMS to recognize my authorization to modify the contents of the folder) Sure, I can stay after the end of my shift for 3 hours on ONE DAY to migrate the data (or come in 3 hours early). but I'd prefer to be able to run a macro that does it all... does anyone have any experience with the VBA .CheckIN method for SharePoint? Thank you, Paul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
