Forum Discussion
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...
Many thanks, once I delete this I receive the same error message Sub or funciton not defined, but for the first row:
Sub ExportComments()
Any advice?
Do you still have the following commented out?
'Dim xlApp As Excel.Application
'Dim xlWB As Excel.Workbook
The code compiles without error here.
'Dim xlApp As Excel.Application
'Dim xlWB As Excel.Workbook
The code compiles without error here.
I'm not 100% sure what this means, once I remove the ' I still have the same error message.
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.
- I have tried this and I still receieve the same error message as before.
