This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft word processing software products for creating web, email, and print documents.
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.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Thank you Snow. This will really help us toward a solution. Now maybe someone who knows VBA for Mac can help translate your work.
Thank you!
Chip
There are 2 issues with this code for a Mac. The minor issue is the path separator, which needs to be "/" instead of "".
Depending on your version of Office, the Dir function could be an issue. It's been fixed in Excel for Mac 2019 and Excel 365, but does not work in earlier versions. I haven't tested whether Dir is working in Word VBA. Here is Ron de Bruin's page about this issue: Dir function in macOS
Snow,
I cut and pasted the Macro you posted and put it into Word on my Mac and ran it. There were no compile error on the front end. It did seem to go through all the files in the folder, but it only processed the .pdfs for some reason. It didn't appear to do anything to the docx or out files.
Chip
John,
Thanks for the reply. I didn’t see which line has the slash reversed. Can you be more specific?
I am running the most current version of Word that comes with the office 365 subscription. I didn’t get any compile errors when I tried to run Snow’s macro on my Mac. That said, it did not perform the routines as expected.