+ Reply to Thread
Results 1 to 3 of 3

Want to export value in word bookmark to excel sheet rows

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Want to export value in word bookmark to excel sheet rows

    Hi All,

    I want to export value in word bookmark to excel sheet rows. Now what i want is

    I have a word file having text value bookmarks and check mark bookmark, i want all the text value and check mark value get exported in excel sheet. I given an example in excel sheet how it look in look.

    Now when user check the check mark then in excel sheet it should come "Yes" value and in the text area whatever the value user input that also get exported in excel sheet. I hope when you see the excel sheet you will get the idea what i want..

    REgards,
    HD
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Want to export value in word bookmark to excel sheet rows

    In a module in Word, add this code.

    Set the Excel reference in the VBE.

    You'll still have a problem of running the macro with the document protected.

    I usually create a ribbon so that I don't have to open the VBE to run it.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Want to export value in word bookmark to excel sheet rows

    Hi @Tinbendr

    Thanks You Very Much Bro.. Its Working Fine For Me.. Thanks A Lot...

+ 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. excel value to word bookmark - macro to keep formatting
    By excelor100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2017, 07:24 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. Export a excel sheet to word doc
    By vijitgpt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2013, 01:09 AM
  5. importing text from bookmark in Word to excel
    By mayanklal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2006, 10:23 AM
  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. Replies: 3
    Last Post: 12-16-2005, 07:00 PM

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