Sharepoint Checkin|VBA & Macros|Excel Forum|My Online Training Hub

Hi All,

Aiming is to create separate file from a big file.

So if column E="ABC", then copy paste data of ABC to a blank new file and save it on sharepiont and check-in the file

if Column E="EFT", then copy paste data of ABC to a blank new file and save it on sharepiont and check-in the file

Marco works except check-in function, error message is "We can't do that because the file is no longer checked out or has been deleted".

But the file is actually created and saved in sharepoint as check-out.

File is attached, please help.