Forum Discussion
Help with Paste from excel to word
Hi everyone!
there is something going on that i really cant figure out..
i have an excell file with a table, few columns lot of rows, and a lot of pictures!
if i select the whole 'space/stable' copy and paste on WORD 2010 it works perfectly fine (i can give the file with the result) but if i paste into WORD 2016 it screw up everything..
i've cheked like aaaall the options in words, even comparing between the two version, but i really cant figure out whats the problem is!
can someone give any type of help?
Tommaso_Bertocchi I apologize in advance if this makes you cry.
Using Visual Basic in Word, you can add a table to a document using a command such as
The table will be added to the Range, which can be defined in a number of ways. For example if the table was to be added at the end of the document, you would use
Dim NewTable As Table
Dim tblRange As Range
Set tblRange = ActiveDocument.Range
tblRange. Collapse wdCollapseEnd
Set NewTable = ActiveDocument.Tables.Add(tblRange, NumRows, NumColumns, etc)
While you would usually set the tolal number of columns when adding the table, in most cases you would not set the total number of rows as you can simply use
NewTable.Rows.Add
whenever a new row is required.
The following is a listing of the members of the Table class
As an example, this is a screen shot of onw of the tables in an 1100 page document that was created, populated with text and formatted using a visual basic routine run from an Access database
- If you upload a copy of the Excel Workbook and the Word documents, one of use may be able to determine the cause of the issue and provide a work-around.
Goodmorning! thanks for the reply, here are the links:
note: excel file have a macro to copy the area that needed to be pasted, feel free to keep macro disabled if you dont trust it and manually select the whole table( 3-612, D-J)
www.martel.it/File_uso_interno/Example.xlsm
www.martel.it/File_uso_interno/word2010-right.docx
www.martel.it/File_uso_interno/word2016-wrong.docx
p.s. i'm worried it could be a problem not related to excel/word, but with the clipboard of windows10 wich maybe is too slow?thanks in advance!
- When opened in a 64bit installation of Microsoft 365 Apps for enterprise, Version 2208 (Build 15601.20148 Click-to-Run) Curret Channel, both the Word2010-right and Word2016-wrong documents appear to be complete and identical with all of the images from teh Excel workbook.
However, if I try to copy and paste into a Word document in the above version of Office, very few of the images are present in the document.
I guess the question is, why do you need to move from Excel to Word?
