+ Reply to Thread
Results 1 to 1 of 1

VBA to export cell content to word as formatted text

  1. #1
    Forum Contributor
    Join Date
    08-25-2015
    Location
    London
    MS-Off Ver
    MS 365
    Posts
    213

    Question VBA to export cell content to word as formatted text

    Hi everyone,

    I'm trying to export worksheet cell contents into word as text (not as a table) and format the text at the same time. I found some VBA scripts to export to word, however, these seem to rather copy/paste the whole table structure into word, which is not what I'm trying to do :-(

    I've tried to summarise what I would like the script to do in the attached + I added a screenshot of how the word document should look like.
    Note that I don't want to create a word template that Excel then populates on click of a button, the script should rather open word, open a blank template, copy the cell content over as text (with formatting as described in the file) and add line and page breaks at the same time.

    Still a VBA newbie so a bit lost where to start really. Hope you can help?
    Many thanks!
    Attached Files Attached Files

+ 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. Having excel export a formatted word document
    By rockthecasbah121 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2016, 04:26 PM
  2. Replies: 0
    Last Post: 01-25-2013, 07:03 AM
  3. Export data in formatted plain text?
    By JohnnyDavidson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2011, 05:23 AM
  4. Bringing formatted word content into excel cell
    By zkazi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2009, 02:33 PM
  5. Replies: 4
    Last Post: 12-17-2007, 08:11 AM
  6. Converting 'General' formatted cells to Text formatted cell using.
    By Zahid Khan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2005, 04:06 PM
  7. [SOLVED] How can I export cell content in Excel to a text file?
    By documentum_dan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2005, 02:06 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