Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-28-2015, 01:15 AM
hanvyj hanvyj is offline Windows XP Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting

I'm generating a word doc from a requirements list, and the cells in the description can have quite a lot of text, and it's often formatted with bold or italic within the cell, so only certain words are bold.

Requirement.Description is the Range:

Quote:
Requirement.Description.Select
Selection.Copy
wrdApp.Selection.Paste
This pastes the formatting fine, but even though the range is a single cell, it inserts it into the word document in a table (of a single cell). Unlike the user interface, which just pastes the text.

I also can't use Requirement.Description.Value as that will strip out all the formatting and I'd just get the text.



Does anyone know a way of transferring it over, or copying it with it without having it paste as a table?

Cheers
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
formatting a text box in a table cell clemkonan Word Tables 1 07-20-2015 09:11 PM
Excel Cell Linked to Word Doc - Lock in Formatting? wizzle89 Word 1 06-08-2015 08:33 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? bharathkumarst Excel 7 10-13-2014 10:25 AM
Table with text that flows from cell to cell hwrigley Word Tables 7 02-18-2014 02:59 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM


All times are GMT -7. The time now is 02:37 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft