When launched from Access via VBA, Word open a .tmp file outside the trusted folder (maybe OLE problem)

Question

Hi,

I have an Access form with an OLE BoundObjectFrame holding Word documents.

I repurpose the context menu so I can lauch the Word document by my VBA code.

When a file is opened everything is fine. But when I try to open a second one without closing the first one, Word stop the opening of the file because it's ouside of trusted folders.

But that is not the file path I launched!

I never experieced something similar in earlier versions of Office. Now I'm using Microsoft 365.

Any hint? Thanks

Answer 1

Hi @Lauro Colasanti

For newer versions of Office, Microsoft has made some changes to improve the security of VBA.

• I suggest you go to Word > File > Options > Trust Center > Trust Center Settings > Protected View, untick the box of 'Enabled Protected View for files located in potentially unsafe locations' for a check.
• Besides, you may check the VBA code. Here is a similar thread 'Temporary Word File in ..\INetCache\Content.Word are not trusted - is back', in the comments at the bottom, Leon Pri-Mor said modifying the code to solve this problem.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

Hi,

Thanks for your help, but it didn't solve my problem.

The Word > File > Options > Trust Center > Trust Center Settings > Protected View > 'Enabled Protected View for files located in potentially unsafe locations" is unticked but the notice is still there.

But what seems even more strange is that the notice will appear also if I allow all macros!

And what surprise me is that if I lauch only one file everything is allright. The notice will appear only if I lauch a second file!

Lauro

Answer 3

Hi, some update.

If the Word files in the Ole BoundObjectFrame of Access are opened using the normal double click inside the control everything it's fine.

If the Word files are opened by the following simple VBA code, the first file opens correctly, the second one rises the security warnings.

The code:

sFileName = Me.txtFileName   
On Error Resume Next
Set objWordApp = GetObject("Word.Application")
If Err.Number <> 0 Then Set objWordApp = CreateObject("Word.Application")
On Error GoTo 0
With objWordApp   
.Visible = True   
.Activate   
.Documents.Open sFileName
End With 
Set objWordApp = Nothing