Connect .xlsx file saved in sharepoint with ADODB connection in Excel

[rahulmeher]

Hi,

I am working with 100mb+ xlsx files and trying to access these files save in Share Point.

I tried ADODB connection string to access. If file is saved on local drive, connection works fine but not able to connect data on sharepoint.

Please help.

My Connection Code ==

""
Set rs = New ADODB.Recordset
Set cn = New ADODB.Connection

FilePath = "https://companyname/personal/folder1/Documents/Test_Save.xlsx"
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & FilePath & ";Extended Properties=""Excel 12.0 Xml;HDR=Yes"";"

""