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 No comments

53 answers

Sort by: Newest
  1. Jim G 134.1K Reputation points MVP
    2019-09-12T17:00:28+00:00

    Hi Richard,

    The 16.29 update is now a general release build. It should turn up when you use the Help menu and choose Check for Updates to launch AutoUpdate.

    Earlier today someone posted steps on how to clear the recently used file list. The reply was in regard to something other than what you're experiencing, but perhaps following these instructions will reset the recently used file lists for you.

    Clear Recently used files

    https://www.tech-otaku.com/mac/removing-entries-microsoft-office-apps-recent-files-lists-macos/

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-09-11T23:59:26+00:00

    Dear Richard_1931,

    Thanks for your comments and updates.

    When inserting the macro code, please go to the files you want to open>right-click on them>Get Info to check if the files’ paths are correct.

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

    Best Regards,

    Cliff

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-09-11T22:49:13+00:00

    Thanks, Cliff.  I did what you said with Visuals Basic Editor before your posting on it, and it didn't work.  Your file path instructions are baffling to me.  I'm not a techie.  I've also let the Word people know about this problem on two or three occasions since October of last year, and they've done nothing about it. Another responder in the community, Jim Gordon, said a fixed version exists but it's only available if I buy 365 and join a group called the Insider Fast Program, but I don't care to buy a new version, and a subscription at that, and risk wasting more time with problems, so I'll just  wait till a fixed version is publicly available.  Meanwhile, I'll use Pages and hope Word will be fixed before too long, and, by the way, it's not the 2016 version Word that I've had problems with but the 2019 one.  

    Microsoft's handling of this problem has been deplorable, but Word does have a few advantages over other programs, so I'll probably continue using it until something better comes along, I hope.  Microsoft badly needs an ombudsman who can take charge of problems like this where the user has been jerked around for weeks, or months as I have.  The company is alienating people with this sort of treatment--I've talked to others who've had similar experiences--and sooner or later the chickens may come home to roost.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-09-03T08:03:44+00:00

    Dear Richard_1931,

    Thanks for your updates.

    The way I provided works in our environment based on my test. It is also a macro operation as what you do for recording a macro. For recording a macro, you may need to record the operation of opening the files and get the file paths of the files. You can create macro for each file you want to open via Tools>Visual Basic Editor>clicking on Normal (this will let the macros be applied to a newly created file)> Insert>Module to create the macros for opening each file. Yes, you may need to change the file path in the code for each file. I know this may be cumbersome in your environment but it may be at least a viable way in Word 2016 for Mac. If it is an inconvenient way in your environment, I suggest you use the feedback tool in the upper-right corner of your app to our related team directly so that they will be aware of the issue and address your requirement in your environment for further investigation.

    Thanks for your understanding.

    Cliff

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-09-02T17:51:41+00:00

    I tried to reply to your previous message and kept getting this error notice: Oops! Something went wrong. Please try again.

    Here's the reply I was trying to post.

    Sorry about the delay in responding to this.  I appreciate your efforts on my behalf.  Meanwhile, I got an email  from someone named Randy at the "Microsoft Answer Desk" saying they'd tried to reproduce the macros problem on ten computers and hadn't been able to and I wrote him back about what they might be doing wrong and he wrote asking for a link to the Community thread, which I just supplied him.

    I've tried to change the file paths as you recommended and quickly ran into a problem.  When I open Tools>Visual Basic Editor, I can't find any button there for insert.  What I get is a page headed with the name of the document I'm working with and two options in a bar along the top, (General) and (Declarations).  Clicking on the general down arrow I get two options, General and Document.  Do I just click on one of those and enter the code you sent me on the page?

    There's a dropdown menu on the left of the page with Normal at the top followed by Project (name of document) under which appears Microsoft Word Objects and References with This Document as a subheading under Word Objects.  Below that when This Document is highlighted is a list headed Properties-This Document.  I clicked on everything clickable but nowhere do I find the word Issue.

    One more question about this.  Does the code you've provided me fix the problem for all my Word documents if I use the 

    General option, or do I have to do the file path change for each one individually?  The latter would be cumbersome, as I have 30 or more documents I use macros to open.

    Thanks again for your continuing efforts.

    **** Greene

    Was this answer helpful?

    0 comments No comments