Hello all,

I am trying to automate an excel file from sharepoint to be updated every time a specific email is received all using VBA. I have almost EVERYTHING figured out except when I have to check the file back in to sharepoint. I tried the CheckIn method and followed the countless examples I found online that supposedly work. However, it never works for me.
So I've been trying to figure out a workaround...

When I save and close the file on VBA a notification pops up asking if I'd also like to check in the file to sharepoint. HERE is where I'd like to be able to select YES so that the excel file gets checked in. Does anyone know how to automate this with VBA? Simply putting Application.DisplayAlerts = false will not work because it doesn't actually check in the sharepoint file after my file closes, it just eliminates the alert. Any suggestions?