Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying excel info into word
How can i copy a column of excel information into a Word document, and have
the style change it into a paragraph format? For instance if i have a column of drawing numbers, i'd like to insert them into a word document but in a pargraph form, hopefully separated by commas? Possible? Or am I expecting too much? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying excel info into word
Eric
You could place the column of numbers into one comma-delimited cell in Excel then copy that one cell into Word. Sub ConCat_Cells() Dim x As Range Dim y As Range Dim z As Range Dim w As String Dim sbuf As String On Error GoTo endit w = InputBox("Enter the Type of De-limiter Desired") Set z = Application.InputBox("Select Destination Cell", _ "Destination Cell", , , , , , 8) Application.SendKeys "+{F8}" Set x = Application.InputBox("Select Cells...Contiguous or Non-Contiguous", _ "Cells Selection", , , , , , 8) For Each y In x If Len(y.text) 0 Then sbuf = sbuf & y.text & w Next z = Left(sbuf, Len(sbuf) - 1) Exit Sub endit: MsgBox "Nothing Selected. Please try again." End Sub Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 07:25:04 -0700, EricS wrote: How can i copy a column of excel information into a Word document, and have the style change it into a paragraph format? For instance if i have a column of drawing numbers, i'd like to insert them into a word document but in a pargraph form, hopefully separated by commas? Possible? Or am I expecting too much? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying excel info into word
Find, and replace the "paragraph mark" with a "comma" in Word.
EricS wrote: How can i copy a column of excel information into a Word document, and have the style change it into a paragraph format? For instance if i have a column of drawing numbers, i'd like to insert them into a word document but in a pargraph form, hopefully separated by commas? Possible? Or am I expecting too much? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying info from a Browser window into Excel | Excel Worksheet Functions | |||
pasting Word table info into Excel | Excel Discussion (Misc queries) | |||
Am I able to link excel info with word and have it change when i c | New Users to Excel | |||
Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
getting specific info from a word document into excel | Excel Discussion (Misc queries) |