Forum Discussion

UCTQYAV's avatar
UCTQYAV
Copper Contributor
Sep 01, 2022

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...
VBA
Doug_Robbins_Word_MVP's avatar
Doug_Robbins_Word_MVP
MVP
Sep 01, 2022
You will need to show the code for anyone to be able to trouble shoot it for you.
UCTQYAV's avatar
UCTQYAV
Copper Contributor
Sep 02, 2022
Code added in!
  • Doug_Robbins_Word_MVP's avatar
    Doug_Robbins_Word_MVP
    MVP
    Sep 02, 2022

    UCTQYAV Delete:

     

    Private Sub Document_New()

     

    End Sub

     

    They serve no purpose.

    • UCTQYAV's avatar
      UCTQYAV
      Copper Contributor
      Sep 06, 2022

      Doug_Robbins_Word_MVP 

       

      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?

      • Doug_Robbins_Word_MVP's avatar
        Doug_Robbins_Word_MVP
        MVP
        Sep 06, 2022
        Do you still have the following commented out?

        'Dim xlApp As Excel.Application
        'Dim xlWB As Excel.Workbook

        The code compiles without error here.

Resources