Creating a VBA Excel macro that creates an Outlook meeting invitation using text and formatting from a Word document. (Office 365)
The macro mostly works, but it has weird behavior: I need to have the Word document open, or else I get errors. Also, it takes a while to execute and tries opening the doc again in read-only. I’m definitely not using best practices here (next on my list is to use named ranges instead of Column A). I would like some suggestions for making it run better so I can pass it on to others.
This command is not accessible since there isn’t an open document
Here is my code; I need help fixing this error code. I want to run the code once and have my pivot and chart table shown.