Hello, fisrt I am sorry if this is the wrong place to post, but I have looked everywhere I was unable to fin the answer to my problem, in there you will find part of my code

AddNew newBook, sFileName // Creates a new file
newBook.Activate

//After this I have a prompt asking me If i want to replace the existing file, I do, so I disable the Alerts to automatically do it.
Application.DisplayAlerts = False

// I save this file to a SharePoint, the thing is after the file is saved is put in CHECK OUT mode which block any other user from ussing this file, this is how the SharePoint works I have no control over this

newBook.SaveAs "https://channelone.cognizant.com/sites/Shared%20Workspace/Argentina/NVIS/Asset%20Library/Carpeta%20De%20Prueba%20-%20No%20Borrar%20Por%20Favor/" & sFileName


Application.DisplayAlerts = True // Enable alerts

//This is my problem
ActiveWorkbook.Close SaveChanges:=True


In order for me to remove the CHECK OUT mode from the file I need to close the excel and do a CHECK IN, problems is after trying to close the file I get a prompt asking me If i want to check in but the default answer is to NOT DO THE CHECK IN so if I use DisplayAlerts = False excel will automatically select the option NO and I need to select the option YES

is there a way to tell excel that it needs to select "YES" and "OK" on every prompt regardless of what the default answer is?


I hope I was clear, sorry for my english

Thanks in advanced