How to select "yes" when prompted to check in sharepoint file using VBA

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?

Here is solution that works for me:

Please Login or Register  to view this content.

Note that even though the CheckIn function checks in the file, it will not show as checked in in SharePoint until you close it, hence the Workbooks.Close command.

Hope this helps

Derek