ADODB connection string on sharepoint

[vladk]

Hi,

I have some VBA code inside Excel.

This is the piece of code that does work on the network, but not on the sharepoint:

Set ioobjConn = New ADODB.Connection
Set ioobjCmnd = New ADODB.Command

Dim strCnctn As String

strCnctn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & ThisWorkbook.FullName & ";" & _
"Extended Properties=""Excel 8.0;HDR=No"";"

With ioobjConn
.ConnectionString = strCnctn
.CursorLocation = ADODB.adUseClient
.Open
End With


The problem is ThisWorkbook.FullName

On sharepoint it is some http:\..... path, and ADODB connection object dooes not like it. On hard drive it works well...

Can anybody help me?

Thank you!!!

Vlad

 

[PatrickIRL]

Not sure if this helps ....

http://www.connectionstrings.com/sharepoint

Patrick

 

[vladk]

PatrickIRL,

Thank you for the answer, I will need to try it somehow...

Thank you again!

Vlad