• VBA code to paste Excel data to Word (Office 2000)

    Home » Forums » AskWoody support » Productivity software by function » Productivity software by function – other » VBA code to paste Excel data to Word (Office 2000)

    Author
    Topic
    #374907

    I am trying to Paste data ( Table) from an Excel workbook to the end of a Word document . I am using – “Selection.EndKey Unit:=wdstory” to locate the end of the Word document, but the Macro won’t recognise the code. Can anyone help? Full VBA code attached.

    Viewing 1 reply thread
    Author
    Replies
    • #608032

      For a start, I think this line

      ‘Documents.Open Filename:=”C:MyDocumentsTime.doc”
      should start with a dot, not a comment mark, otherwise you do hot have an open document to work with.

    • #608072

      Brian, please do NOT triple-post, not even double-post !

    Viewing 1 reply thread
    Reply To: VBA code to paste Excel data to Word (Office 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: