none
Connecting Excel to SharePoint RRS feed

  • Question

  • Hi,

    We're developing a macro that connects Excel to SharePoint and uploads selected data from the worksheet. It is working on the majority of our computers, but on some it doesn't work and an error that says "Can't Find Installable ISAM" shows up.

    When we debug the VBA code it's not working on the line ".Open", below: (I hid the database and the list)

    With cnt 
    .ConnectionString = _
    "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE='sharepoint link';LIST={'sharepoint list'};"
     .Open
     End With

    Does anyone have any idea how to solve it?

    Thanks!

    Wednesday, January 22, 2020 1:31 PM