Wise Owl Answers - How do I resize a Word table after copying from Excel?

Check out our other answers here • Wise Owl Answers
Get files here www.wiseowl.co.uk/vba-macros/...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!
If you copy data from Excel to Word what happens if the table is too big for the page? This video shows you how to control the width of table columns in Word to make sure that everything fits on the page.
Chapters
00:00 The Question
00:44 Referencing the Word Object Library
01:34 Copying Excel Data to Word
02:49 Using the Autofit Method
04:14 Making Columns the Same Width
04:41 Setting the Preferred Width of the Table
05:37 Reducing the Table Width
07:12 Looping Through the Worksheets Collection
08:53 Adding Page Breaks
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more

[@piotrkuc8936]

I truly admire the way you explaining and teaching. It's easy to follow and is a pleasure by itself.

[@WiseOwlTutorials]

Thank you Piotr, happy to hear you're enjoying the videos!

[@krn14242]

Thanks Andrew.

[@wayneedmondson1065]

Awesome Andrew! You make it look so easy.. haha!! Always enjoy your videos and learn something new from them. Thanks for sharing :)) Thumbs up!!

[@WiseOwlTutorials]

Cheers Wayne! Happy to hear that you liked that one. Thanks as ever for your comments and support!

[@KhalilYasser]

Awesome. Thanks a lot my tutor.

[@WiseOwlTutorials]

Thank you Yasser!

[@pedrohzan]

Amazing content!

[@WiseOwlTutorials]

Thank you Pedro, happy to hear that you enjoyed it!

[@youssefsedkey7616]

wonderful, Mr. Andy.

[@WiseOwlTutorials]

Thank you Youssef!

[@henrikijonkoping4694]

I will put up this stream on my to do list! Nice!

[@WiseOwlTutorials]

Thanks Henrik, glad you enjoyed it!

[@jenlam4466]

Thank you so much for the video but I am struggling with the merged cells. Why the merged cells have became unmerged when it copied into word?

[@WiseOwlTutorials]

Hi! You could try using the PasteExcelTable method to retain Excel's formatting: wd.Selection.PasteExcelTable _ LinkedToExcel:=False, _ WordFormatting:=False, _ RTF:=False I hope it helps!

[@jerrydellasala7643]

Great tip! It bothered me that the tables had no grid lines. A quick search revealed that adding the line ActiveDocument.ActiveWindow.View.TableGridlines = True just before the two backspace lines did exactly what I wanted. Thanks!

[@WiseOwlTutorials]

Excellent, thanks for sharing that Jerry!

[@user-qi4lr7ii3r]

Please help For referring tables in a word file, I'm utilizing the table title property in my Excel VBA code. I build three tables in my word document and label them "Data_1," "Data_2," and "Data_3." by conducting a Role_1, Role_2 and Role_3 text search in the fourth column of Excel Sheet 1. I have to paste Role_1 data into a word document with the table name "Data_1," and so forth. ( for roles I'm using current region property)

[@chuderflunderchunder8117]

Awesome, thanks for this content. Is posible you can explain the reverse thing? Copy tables from word to excel?

[@WiseOwlTutorials]

Sure! I'll add this question to my list!

[@The_Code_Father]

Great video Mr Andrew but what if i wanna decrease the word page border for the tables only without affecting the other data to be entered in this document apart from this copying code i mean after saving this word document of course

[@ElWiwif]

Hello Owl Master. Thanks for sharing! :) Quick question: In a situation "Excel to Word", similar to this example, is there an option to autofit columns by late binding?

[@WiseOwlTutorials]

Hi Brian! You can use the same methods in late binding as in early binding. Is there something that isn't working for you?

[@arvindkumarauro9731]

Hi sir first I want say thank you so much such knowledgable videos. And second I want to request you, could you please teach us how to add headers along with company logo pic in word doc after pasting the table from Excel...

[@WiseOwlTutorials]

Hi Arvind, I'll add that question to my list, thanks!

[@arvindkumarauro9731]

@@WiseOwlTutorials thank you so much sir..!!

[@WiseOwlTutorials]

@@arvindkumarauro9731 No problem!

[@excluzive.]

Thank you for your work, sir! How do I control over another application (outside MS office package) using VBA? For example I need to find some keywords in Adobe Acrobat Reader DC? I thought that I could open search field using CTRL+F and then pass a value to it. But I can't figure out how to do it.

[@phaedrusg3232]

Try converting the PDF file to a Word file first.

[@WiseOwlTutorials]

Hi there! If you can find a library which you can reference in your VBA project from Tools | References... that will help! Here's some advice for how to download the Acrobat SDK stackoverflow.com/questions/60352098/cant-find-the-adobe-acrobat-10-0-type-library-2020 Then you have to hope that someone has written helpful documentation for the library! Fortunately, there's a nice online resource for the Acrobat SDK help.adobe.com/en_US/acrobat/acrobat_dc_sdk/2015/HTMLHelp/index.html#t=Acro12_MasterBook%2FIntroduction_Help_TitlePage%2FAbout_This_Help.htm Good luck!

[@arvindkumarauro9731]

HI sir, my query is how we can adjust columns by one by one on the basis of column data size. becose in my data table there are two or three columns where the data size is like a full narrative/article and two-three columns where the data size is like one or two word. so I have to resize them each column according it's data size. please help me...

[@WiseOwlTutorials]

Hi Arvind! You can set the size of individual columns like so: tbl.Columns(1).Width = 50 tbl.Columns(2).Width = 200 tbl.Columns(3).Width = 100 tbl.Columns(4).Width = 50 I hope it helps!

[@arvindkumarauro9731]

@@WiseOwlTutorials thank you so much sir.i I will use ur given suggestions.