Checking in a Document in SharePoint from Macros

Hi,

We have mapped a network drive to a SharePoint Directory, while we are able to copy a file (using Macros) to this location, this file does not appear in SharePoint to the other users, the reason being that it is not checked in.
Can you help/guide us on how to Check using Excel Macros.

Let me know if you require any further details.

regards,
Saravanan

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