Page 2 of 2 FirstFirst 1 2
Results 21 to 22 of 22

Thread: Macro for replacing EXCEL data into WORD

  1. #21
    Quote Originally Posted by macropod View Post
    The comment in the post about a folder browser was wrong - there isn't one, since only the activedocument is being processed. That's what happens sometimes when boilerplate code is copied without checking the accompanying comments. The code for defining the Excel workbook is:
    StrWkBkNm = "C:\Users\" & Environ("Username") & "\Documents\Workbook Name.xls"
    Thank you, Macropod. I did read all the comments, and I saw how to define the workbook (the code worked for me fine on the defined workbook) - I just wasnt sure if there was a browser since a file browser was mentioned in the comments beneath the code.

  2. #22
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Jul 2008
    I've now deleted the errant comment re a folder browser.
    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts