+ Reply to Thread
Results 1 to 1 of 1

Stop carriage return being enetered after bookmark is populated from excel wb to word doc.

  1. #1
    Forum Contributor
    Join Date
    10-07-2013
    Location
    Wilts, England
    MS-Off Ver
    Excel 2013
    Posts
    100

    Exclamation Stop carriage return being enetered after bookmark is populated from excel wb to word doc.

    Hi all,
    I have been working on a script that codes a command button on a worksheet that opens a word template which has bookmarks saved in a crucial places. The code is working well, but the issue I have is that when the bookmarks are populate a carriage return is generated which throws off all my formatting and pushes the lower bookmarks out of line and adds an unwanted new page.

    Please Login or Register  to view this content.
    I know this is an excel forum and the issue is on the word report, but the code is written in excel VBE so a solution that stays with this code would be best as the finished product will not be used by me, so I wanted to keep things as simple as possible for it's users.

    I have been banging my head up against a wall for the past few days and have come up with nothing workable.
    Any help or advice will be greatly appreciated!!!!!!
    Beth
    Last edited by Fotis1991; 10-22-2013 at 08:23 AM. Reason: Pls use code tags around your code

+ 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. VBA to create named range bookmark that links from a given cell when populated
    By penfolda in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-12-2013, 09:33 AM
  2. [SOLVED] Forcing a carriage return when pasting to a bookmark
    By AndyE in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-02-2013, 02:56 AM
  3. Replies: 17
    Last Post: 01-12-2013, 11:31 AM
  4. VBA paste to word - problem with carriage return
    By wonderdunder in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-03-2010, 04:16 PM
  5. hyperlink from Excel to a Word bookmark
    By Bertie in forum Excel General
    Replies: 2
    Last Post: 05-16-2006, 02:55 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