Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-28-2015, 01:15 AM
hanvyj hanvyj is offline Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting Windows XP Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting Office 2010 32bit
Advanced Beginner
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting
 
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
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting formatting a text box in a table cell clemkonan Word Tables 1 07-20-2015 09:11 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting Excel Cell Linked to Word Doc - Lock in Formatting? wizzle89 Word 1 06-08-2015 08:33 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting 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
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft