run-time 2737 when connecting OLE Object (Word file) who is inside OneDrive Folder-CodePudding

I'm developing a solution based on Word and Access. In an Access mask, the user click a command and a Word file is automacilly created and inserted in a BoundObjectFrame via the following command:

With OleDoc
      .Class = "Word.Document"
      .OLETypeAllowed = acOLELinked
      .SourceDoc = strFullNameFile
      .Action = acOLECreateLink
End With

Everything is fine if the file named strFullNameFile is in a normal folder on my computer. But if is in a subfolder inside my OneDrive folder in my computer, I get a Run-time error 2737 Impossible to find file with OLE object linked...

Do you have any idea why? Thanks, Lauro

CodePudding user response：

You need to pass the path with subfolder too. It's searching the file in main folder.

CodePudding user response：

thanks for you interest. I start to understand what you mean. If from Access I create a new Word Doc, before is is saved its ActiveDocument.FullName is "Document1" and after I save it in a OneDrive folder is "https://d.docs.live.net...docx. Setting "saving always in this device" my OneDrive folder is not helping.