What if I don't update macOS to a supported version? Learn more about the latest macOS releases. The October 2022 update (16.66) is the last build to support macOS Catalina 10.15. Note that new installs of Microsoft 365 for Mac also requires macOS Big Sur 11 or later.
Upgrading your operating system to macOS Big Sur 11 or later will allow Office updates to be delivered for your apps. If you continue with an older version of macOS, your Office apps will still work, but you'll no longer receive any updates including security updates. I do not get an error code as Excel just completely crashes and I have to Force Quit.Starting with the November 2022 update (16.67) macOS Big Sur 11 or later is required receive updates to Word, Excel, PowerPoint, Outlook, OneNote, and Defender. Through running the debug line by line the issue seems to be at the '.paste' part. Tables(1).ConvertToText 1 'wdSeparateByTabs Set wdApp = CreateObject("Word.Application") Set wdApp = GetObject(, "Word.Application") Here is the code that works perfectly fine on Microsoft Office Mac 2011:ĭim wdApp As Object, wdDoc As Object, wdRng As Object The code selects a range of cells in Excel, copys them, opens up Microsoft Word, pastes them then converts the table to text. The current version of office is Microsoft Office 2021 version 16.54. I was using Microsoft Office Mac 2011 but I had to upgrade this as Mac 2011 no longer works on more recently operating systems.
I recently updated my Mac from High Sierra to Big Sur 11.6. Like most on the forum, I am not a coder and all of my VBA is made from adjusting code that other people have created. Hello everyone, I have come across a problem that has not been resolved elsewhere.
0 kommentar(er)
