Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2019, 05:03 PM
Guessed's Avatar
Guessed Guessed is offline Inserting a paragraph character using VBA Windows 10 Inserting a paragraph character using VBA Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Quote:
Originally Posted by pfittro View Post
It will retain the same formatting using a discrete paragraph for each line. Inserting the word document as an embedded object does not populate any cells. Instead it is just a floating block.
The purpose of this is to use excel to quickly draw a table in Revit with notes formatted in Word. Unfortunately Autodesk has not made Revit friendly to bringing in large blocks of notes from Word.
If there is a simple code for my original post please let me know.
There isn't simple code for your original post request. All hanging indented content you add paragraphs in will completely look different and if bulleted or numbered then that would end badly. You would use soft returns (line breaks) rather than paragraph marks to avoid that issue but the result is only marginally better.



I still don't see the problem, if I copy Word content and go to Excel and choose Paste Special > Microsoft Word Document Object (as you said you are doing) then the content appears with the same line wraps that the Word document had.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
insert, paragraph character



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a paragraph character using VBA How to insert paragraph character after every 500 characters? aditya_bokade Word VBA 28 11-13-2021 10:48 PM
Inserting a paragraph character using VBA Replace a character only if it is at the beginning of the paragraph. donpopo Word 2 11-11-2018 11:32 PM
Add paragraph return between two specific character jeffreybrown Word 2 03-30-2017 02:45 PM
Inserting a paragraph character using VBA Can't get rid of Chinese character when inserting citation slavrenz Word 13 05-13-2015 11:47 AM
Inserting a paragraph character using VBA Replace paragraph-marks (line-breaks) in tables with a character-string Aztec Word VBA 2 04-02-2013 10:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 PM.


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