connect to sharepoint list with VBA

[VilMarci]

Dear Community,

I am creating an excel reports that pulls data from different sources like
MSSQL and MySQL.
Fine. Now there's a department who use Sharepoint lists to track events.
I know Access can connect to a SP list and use it as a linked table.
I'd like to skip Access and connect to the list only thru pure VBA like I do
with the others above.
Unfortunately I could not find any source how to do this.
Please advise.

Thanks,
Marton

 

[CDGannon]

Have a look at this post- Using SharePoint list as MailMerge Data Source (Word 2007) - Microsoft Office Word Forum - WordBanter