Paste Excel Data into Word

		Microsoft Office Forums > Microsoft Word > Word VBA
Paste Excel Data into Word

FAQ

Thread Tools

Display Modes

07-08-2022, 09:59 AM

jeffreybrown jeffreybrown is offline

Windows 10 Paste Excel Data into Word

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Thanks Andrew. With the tweak of one line, this works great. It turns out there were 11 paragraph marks being added instead of only one needed. After adding the merge, all is good.

Code:

If Len(wdTable.Rows(i).Range.Cells(1).Range.Text) < 3 Then
   wdTable.Cell(Row:=i, Column:=1).Merge MergeTo:=wdTable.Cell(Row:=i, Column:=11)
   wdTable.Rows(i).ConvertToText Separator:=vbCr
End If

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate form (data from excel) in Word based on drop down list selection (data from excel)	wvlls	Word VBA	1	03-22-2019 02:29 PM
Open Excel, copy & paste data & chart	Tal71	Word VBA	2	08-14-2018 08:28 PM
Paste data in "Accounting"format from Excel into Word changes formatting	cory_0101	Word	4	10-17-2012 12:30 PM
How to Copy data from Outlook mail and Paste it in a Excel sheet?	padhu1989	Outlook	0	09-11-2012 04:07 AM
Using Paste/Special wih Excel data	chickasaw	PowerPoint	0	02-05-2010 10:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:21 AM.