Get information from Sharepoint via VBA

[ino_mart]

All

I am using Excel 2007 to generate a dashboard with information on a Sharepoint list. The list and Excel file are changed very frequently and I must be sure users are using the latest version. That's why I created an extra Sharepoint list which only contains a version number. I now need some VBA-code to check this. I do not want to use DoCmd.TransferSharePointList

I found some partial code on the internet, but it gives me an automation error on the "rs.open"-statement. According information I have found, the SQL-string should be correct.

To retrieve the List-ID, I went to the Sharepoint List Settings. In the URL I copied everything behind the word list. Then I browsed to http://www.albionresearch.com/misc/urlencode.php, I put the string in "Encoded", pressed on URLDecode and used the plain string as List ID.

Furthermore, the full URL of the sharepoint list is something like
http://sharepoint.company.com/compan.../AllItems.aspx

Can someone help me?

Please Login or Register  to view this content.

[yogananda.muthaiah]

Hi,

check in your company share point website does *.iqy format . if there i can provide VBA code to extract the data from sharepoint.

[ino_mart]

The *.iqy format is supported.

Furthermore, for unknown reason the automation error does not occur anymore. But the code now fails on the "rs.Open"-command telling the table[list] cannot be found. I have changed the word the the name of the list, the GUID, ... but I always get the message the given table cannot be found or the path name is incorrect.