It turns out that because our sharepoint requires each person to fill out a number of required file properties before checking it in, it would give me an error when I tried to check it in without assigning them. Now I just need to figure out how to get the macro to fill out some of these...
I am writing a macro that would:
check out a document from sharepoint
open a document on C drive
save (stack) the open document on the sharepoint document
close the file
check in the document.
my code is as follows:
Workbooks.CheckOut "https://site.com/J/TestingFile.xlsx"
Set wbTarget =...