ADODB.Connection Generating Error on File Located on Cloud

[masouder]

I have a simple function that creates an ADO connection to the workbook. I have used the code in countless spreadsheets, never with any problems. Recently, a client starting recieving an error message in the code below on the conn.open line when running the code on a spreadsheet stored in a location on the cloud. It does not happen to all spreadsheets stored in the cloud location, and it does not happen to the spreadsheet in question when running the code from a file on the user's machine.

This really has me stumped. Any ideas?

Thanks!

Function ConnectToSpreadsheet(CurBook As Workbook, conn As Connection)
    ConnectToSpreadsheet = True
    
    On Error Resume Next
    
    'Create the ADODB connection object
    Set conn = New ADODB.Connection

    'Open connection
    conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" & _
            CurBook.FullName & "';Extended Properties='Excel 8.0;HDR=Yes'" ';IMEX=1'"
    
    conn.Open
    
    If Err.Number <> 0 Then
        MsgBox "Could not connect to spreadsheet", vbOKOnly, "Connect To Spreadsheet"
        Set conn = Nothing
        ConnectToSpreadsheet = False
    End If

End Function

[Norie]

What's the error message?

[masouder]

Yes, the error message would have been helpful! It reads, "Format of the initialization string does not conform to the OLE DB specification."

We have since figured out what was causing the issue: there was a dash (-) in the folder name where the file was stored. Once we removed the dash then the code ran without error. Odd that when the files were on a network drive some folders also contained dashes and there were no issues.

Thought this info might be useful.

[skywriter]

Thanks for sharing what was causing the issue.

Please go to the thread tools drop down above your first post and mark the thread as solved.