Manage backlogs, create workflows and execute sprints Plan projects, track progress and manage resourcesīuild comprehensive project plans and organize tasks Streamline IT processes and scale up with ease Reduce lead time, ensure quality and perfect your processĬreate schedules, manage crews and deliver under budget Share files, add comments, and work together in real-timeĬreate automated workflows and improve productivityįor small-to-medium teams that need to manage robust projectsįor medium-to-large teams that need to optimize portfoliosįor organizations that need customized security and priority support Organize and manage your tasks to boost team productivity Prioritize and execute your work with transparency and agility Generate in-depth, easy-to-read reports to share progress Manage portfolios, align objectives and get high-level overviews Set milestones, connect dependencies and track progressĬollect and view real-time data on your work for key insights I do not get an error code as Excel just completely crashes and I have to Force Quit.Learn more about ProjectManager and how it can improve your businessĭiscover app combinations that improve your productivity 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)
