How to create a macro on a Mac that opens and does a SavesAs on all files in a folder?

Anonymous
2023-01-18T01:39:42+00:00

I have several hundred Word files that need to be opened, saved in .odt format, then re-opened and saved in .docx (This eliminates an error message I get every time I open the files). I have very limited experience coding in VBA, so I am not sure how to structure the macro. I would be grateful for your help in automating this process through the use of a macro.

Thank you.

Microsoft 365 and Office | Word | For home | MacOS

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

16 answers

Sort by: Most helpful
  1. Doug Robbins - MVP - Office Apps and Services 323.5K Reputation points MVP Volunteer Moderator
    2023-01-20T19:53:40+00:00

    You can turn off alerts by using

      Application.DisplayAlerts = wdAlertsNone 
    

    You should later use

     Application.DisplayAlerts = wdAlertsAll 
    

    to turn them back on.

    Was this answer helpful?

    0 comments No comments