macros disappearing - Word 2019 for Mac

Anonymous
2019-08-21T18:34:26+00:00

When I create macros in the 2019 version of Word for Mac as a way of opening frequently used files, the macros work immediately after I create them, but then anywhere from a few minutes to a day later I get the following error message: "Sorry, we can't find your file.  Was it moved renamed or deleted."  I didn't have this problem with the previous version of Word for Mac or any of the earlier versions of Word I used from back to about the late 1980s, tho those were for Windows-based PCs.

Does anyone have any idea what's causing this problem and how to fix it?

FYI, I'm creating the macros the way I always did, clicking on Tools, then Macros, then Record Macro, then entering in the Keyboard Shortcut box the keys I want to use, then opening the file I want to create access to, then going back to Tools and clicking Macros and End Recording.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

53 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-21T16:55:09+00:00

    I checked out the macros just now, and they've already stopped working.  I get that familiar message:

                     "Visual Basic for Applications

    Run-time error '5174':

    Sorry, we couldn't find your file.  Was it removed, renamed, or

    deleted?

     (CALENDAR.docx)"  [CALENDAR is the file name.]  

    Then below that buttons Help, Continue, End and Debug.  Help produces the message "Sorry, the page you're looking for can't be found."  Continue is greyed out, Debug produces a page for debugging that is utterly mysterious to me and End closes the message.

    As I've said before.  I had no problem with macros with the 2010 version of Word.  The problem just began when I installed the 2019 version, first as part of the Home and Student version of Office Suite, then in what I was told is the professional version of Word.  I've spent many hours on this, most recently with you and Cliff Gu, listed as Microsoft Agent | Moderator.  Cliff's last word was to send a report of the problem using the feedback button which I did a day or two ago, but having spent many hours beginning almost a year ago and running through early this year communicating with Word experts and others in Microsoft, I'm not optimistic.  

    I assume that the underlying problem is that the malfunction I'm experiencing requires reprogramming of Word for Mac, and that no one has gotten around to that.   The problem probably has also probably not been properly addressed because macros work at first, then stop working after a few hours to a few days, and I suspect that those who think the problem has been solved have not checked back after a few days to see if the macros they created are still working.  I know that happened in at least three cases during the time I've been working with Microsoft on this problem.    

    As I keep saying, Microsoft, needs an Ombudsman for problems that don't get solved in the normal manner, someone with the power to cut through the bureaucracy and assure that a solution is achieved.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-09-21T01:59:06+00:00

    Thanks.  It self-installed this morning and I've created a few macros.  I'll let you know in a few days if they hold up.

    Was this answer helpful?

    0 comments
  3. Jim G 134.1K Reputation points MVP
    2019-09-20T16:53:55+00:00

    Hi Richard

    There is now 1 6.29.1 update. Please test it to see if it fixes the problem for you.

    Thanks.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-09-20T02:41:26+00:00

    I assumed discussion with the Office people at Microsoft would lead to a solution, but have followed your advice and sent feedback using the feedback tool.   Keeping my fingers crossed, but not holding my breath.  Microsoft's failures to respond to my many outreaches to date makes me skeptical.

    Thanks for your efforts.

    RG

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-09-19T23:23:33+00:00

    Dear Richard_1931,

    Thanks for your updates.

    Given the situation, I suggest you use the feedback tool in the upper-right corner of your app to report the issue to our related team directly so that they will be aware of the issue and address your requirement with more resources in your environment for further investigation.

    Best Regards,

    Cliff

    Was this answer helpful?

    0 comments