"Microsoft has blocked macros from running because the source of this file is untrusted"

Nicholas Mirro 6 Reputation points
2022-09-14T04:13:54.93+00:00

It's this file ...Windows\INetCache\Content.Word\~WRC0000.tmp

I'm using office 365 and use Word .dotm and .docm files. Lots of macros and Visual Basic. All macros and VBA project are trusted.

I'm still running Microsoft Access 2003, which Microsoft has stated is still functional in Windows 10. We've never upgraded because Microsoft removed critical features on two occasions, stranding us.

A Visual Basic function in Access opens local Word documents based on an Access query. This no longer works and so I cannot retrieve reports based on Access queries.

I've been using these VB routines for years without this issue. A new Office or Windows update caused this. I have no idea which particular update, since both are coming in frequently

Please give me a solution or workaround. My practice is mostly report writing and so this developer oversight is paralyzing my workflow.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
868 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. William Light 81 Reputation points
    2022-09-14T04:24:05.433+00:00

    Please provide granular details on the exact process, start to finish\step by step of how your process works. Also, if you receive the popup the source of this file is untrusted then it is certainly untrusted.

    Regards,

    Bill Light

    0 comments No comments

  2. Karl Donaubauer 1,726 Reputation points MVP
    2022-09-14T10:02:31.117+00:00

    Hi,

    Yes, Microsoft is doing this increasingly starting with April. Here's the documentation.

    Check every involved Office file and remove the MOTW if you can.

    Servus
    Karl
    Access News
    Access DevCon


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.