ADODB Connection string for Excel files located on OneDrive

Hi,

I have a process where I use an ADODB connection to retrieve record data from an excel file:

Please Login or Register  to view this content.

This all works perfectly well provided the Excel file (or strDataFileNamePassed) is a folder location on my local PC or mapped network drive. However, if I move the Excel file to OneDrive then when the code runs to the the line: .Open strConnection there is a long delay where nothing happens and after about 45 seconds I get:

Error -2147467259 The Microsoft Access database engine could not open or write to the file (file name). It is already opened exclusively by another user or you need permission to open and write to the file.

The file certainly isn't opened. Does anyone know how to resolve this issue.

Thank you.

Try to implement such a fragment into your code:

Please Login or Register  to view this content.

Probably, instead of OneDriveCommercial you can also use OneDrive.

Artik

No, your line with VBA.Environs("OneDrive") throws and error. The actual path passed is:

"XXXXX:**d.docs.live.net*b0009d54416167de*Desktop\This is a test.xlsx" (where XXXXX is https and * is a forward slash)

What path should I try to be creating? Thank you.

Does VBA.Environ$("OneDriveCommercial") return the same path?

Artik

BTW. Not VBA.Environs("OneDrive") but VBA.Environ$("OneDrive").

Artik