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!

Please Login or Register  to view this content.

[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.