+ Reply to Thread
Results 1 to 3 of 3

From clicking Excel button, how to jump to top of word document's selected bookmark?

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    Phoenix, Arizona
    MS-Off Ver
    MS 365, 2019
    Posts
    2

    Exclamation From clicking Excel button, how to jump to top of word document's selected bookmark?

    Hello all,
    I am creating an Excel flowchart with buttons for each step that when clicked, open a Word doc with instructions. I've bookmarked each step in the Word doc and the code works to bring the user there, however I would like for the selected bookmark to appear at the top of the page, and currently it is displaying towards the bottom which will confuse my users. I've not done any VBA with Word so I have no experience here, and would appreciate any help you can give! I've attached a screenshot of what it looks like right now, and as you can see, Step 4 is selected, but not at the top of the page. I've attached the Word doc so you can see how it opens. I need that Step 4 to be at the top!! Please help!! I've posted on other forums but gotten no replies.

    Here's my code so far:
    Please Login or Register  to view this content.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: From clicking Excel button, how to jump to top of word document's selected bookmark?

    Hi Erin81, wwelcome to the forum.

    I have a workaround here, but since you did not enclose any documents, I had to apply my own docx, so you have to do the necessary changes.
    Basically you go first to the end of the document and then goto the bookmark:
    Please Login or Register  to view this content.
    Cheers
    Erwin
    Last edited by Eastw00d; 02-26-2021 at 12:15 AM. Reason: additional info
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Registered User
    Join Date
    02-24-2021
    Location
    Phoenix, Arizona
    MS-Off Ver
    MS 365, 2019
    Posts
    2

    Re: From clicking Excel button, how to jump to top of word document's selected bookmark?

    Erwin,
    Thanks so much for your reply! I was losing hope anyone would. I will try that out and let you know how it goes!

    Erin

+ 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. Hyperlink from Excel file to open a Word Document and target a specific Bookmark
    By John Fletcher in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-19-2017, 10:42 AM
  2. 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
  3. Copy Selected Objects from Excel to Outlook as Word Document Attachments
    By singerbatfink in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2015, 08:01 AM
  4. With excel to print a selected page from a word document
    By eb4927 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-15-2014, 05:54 PM
  5. Vba Excel to word; deleting all text from last bookmark to end of document
    By julhs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-19-2014, 04:52 PM
  6. 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
  7. Replies: 3
    Last Post: 07-29-2010, 06:47 PM

Tags for this Thread

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