+ Reply to Thread
Results 1 to 7 of 7

Excel VBA code to bring cell data into Word bookmark

  1. #1
    Forum Contributor
    Join Date
    07-08-2008
    Location
    New York City
    MS-Off Ver
    2013-2016
    Posts
    157

    Excel VBA code to bring cell data into Word bookmark

    Hi, I've been trying for a few days now, modifying code from the internet, to find a clear way of importing Excel cell data into Word bookmarks. I only have a very superficial understanding of VBA and can't figure out how to make the two programs work seamlessly. The code I found helps me with the opening documents and things like that but I need something that helps me import scattered cells on a worksheet into a bookmarked template in Word. I don't want to use Mail Merge feature or Word macros. I need Excel to take care of everything, preferably keeping it clean and simple by performing the cell copy and bookmark replacing in one (ideally) or two lines of code per operation.
    Could anyone offer their knowledge to help me solve this problem? It might be very simple but I can't make it work on my own.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Excel VBA code to bring cell data into Word bookmark

    How are you linking the data in Excel to the bookmarks in Word?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-08-2008
    Location
    New York City
    MS-Off Ver
    2013-2016
    Posts
    157

    Re: Excel VBA code to bring cell data into Word bookmark

    I was hoping I could just use the cell reference or create labels for each cell. I don't know any other way.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Excel VBA code to bring cell data into Word bookmark

    Do you mean name the cells with the same name as the bookmark you want the value in the cell to go to?

  5. #5
    Forum Contributor
    Join Date
    07-08-2008
    Location
    New York City
    MS-Off Ver
    2013-2016
    Posts
    157

    Re: Excel VBA code to bring cell data into Word bookmark

    Something like that. Is there a better way?

  6. #6
    Forum Contributor
    Join Date
    07-08-2008
    Location
    New York City
    MS-Off Ver
    2013-2016
    Posts
    157

    Re: Excel VBA code to bring cell data into Word bookmark

    I figured it out on my own after a couple days of trying different combinations. I'm surprised no one was able to help me with this as it seems to be a simple solution if you know the language.
    The code I needed is:

    Please Login or Register  to view this content.

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Excel VBA code to bring cell data into Word bookmark

    Pretty sure someone would have been able to help if they had a little bit more info.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. In Excel, Word Document hyperlink Table Cell partial text to bookmark.
    By Kalithro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2016, 11:16 PM
  2. Export image from Excel to Word bookmark
    By littlecabbage336 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2015, 01:49 PM
  3. export excel range data populate to word bookmark
    By hyn1999 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2014, 05:01 AM
  4. Unwanted table/end of cell markers when copying from Excel to Word bookmark
    By steve61 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2014, 12:39 PM
  5. add additional data to word document's bookmark in excel
    By RonNCmale in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2011, 04:14 PM
  6. hyperlink from Excel to a Word bookmark
    By Bertie in forum Excel General
    Replies: 2
    Last Post: 05-16-2006, 02:55 PM
  7. [SOLVED] How to copy cells excel data and paste them under MS Word bookmark
    By Bon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2006, 11:40 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1