Forum Discussion
UCTQYAV
Sep 01, 2022Copper Contributor
VBA issue
I have a VBA code and instructions on how to add this into word. The code will take the comments from the word document and add them into a new excel sheet. Whenever I run the code I get the error me...
UCTQYAV
Copper Contributor
I'm not 100% sure what this means, once I remove the ' I still have the same error message.
Sep 07, 2022
It appears that you have inserted the code into the This Document object. Try inserting a Module into the project and then move the code into that Module.
- UCTQYAVSep 07, 2022Copper ContributorI have tried this and I still receieve the same error message as before.
- Sep 07, 2022I note that you are using an Apple computer. Unfortunately, the implementaiton of Visual Basic for Applications on such computers is not the equivalent of its implementation on a Windows computer and it may be because of that that the code does not work for you.
You might ask about the issue, (including the code) in the following Answers forum, which is frequented by a number of users of Mac computers who may be able to help.
https://answers.microsoft.com/en-us/msoffice/forum