Get SharePoint List data.

[Smolar]

Hello,

I'm struggling with combining SP and Excel. I've got a document lib. on SP with metadata FileName/Checked Out To/Modified by in normal view. My macro is going to open one of these files stored on SP. What I need to do is to verify if file, which I'd like to open, is Checked Out and, if so, to whom. The first part (verification if checked out) I have, but I can't handle with the second one. I actually dunno what I suppose to use - SOAP, OLE or what. I will be very grateful for any help/suggestions/pieces of code . Thanks in advance, cheers.

 

[Smolar]

Bump - As far as I've tried, SOAP didn't manage to do it cause it's not a list but a document library. I've manage to write some code to read list info, but this won't be useful. Maybe I'll change the question - Is it possible to get information about TO WHOM file is checked out from Excel (vba) level? Thanks in advance.

 

[MikeDBMan]

This post is pretty old. I think I have code to do this. Do you still need it?