I have long been loading .xlsx files from a SharePoint site by executing a VBA project that has in it basically this code:
Workbooks.Open FileName:=ThePath & TheFile2
Now, all of a sudden, the files are NOT CHECKED OUT. I can't figure out how to issue code to check them out and I sure don't want to have to manually check them out as I load dozens, modify them, and then save them back to SharePoint all the time. Does anyone have any suggestions on how to automate the checking out of SharePoint files. When I try to just record a macro, it creates something like this:
ExecuteExcel4Macro _
"(""https://central.icxt.com/corp/acctg/projects/Project Accounting/Chembio/Enzymes/Project Management/201103 Billing – 3300.xlsx"",48)"
But if I try to re-execute this code, I get an error, Runtime Error 1004, which tells me nothing. Suggestions?
