Free Excel VBA Course #35 - Creating Word Reports Using VBA

In this video, I will show you how to create word documents using Excel VBA and how to copy and paste data from Excel to Word.
The video covers:
-- Early and Late binding
-- Creating a new word document
-- Copying data from Excel to Word and saving it
-- Convert Early binding to late binding
✅ Download File: bit.ly/33HlFDs
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial

[@bhupiistersingh4097]

Now, this is what I call a quality tutorial, not just to get one youtube video on the internet but how your yourself would want things to be explained. Kudos to you...

[@rameshthangaraj6590]

How to autofit excel table in word using your modules

[@VanCamelCat]

This was an absolutely beautiful tutorial. You are a great guide! Thank you for being so detailed, so well organized, and such a great teacher. Keep it up 👍 👍

[@sazenfrog]

First macro I've ever written and it works really well. Many thanks for this clearly explained tutorial.

[@CollDott]

Extremely useful!! So late binding would be preferred as it doesn't bother anyone to go check object library and output the same stuff! But of course I need my word object library checked anyway for outlook use! Thank you!!

[@sugunalakshmanan2196]

Your teaching is very clear. So nice of you.

[@trumpexcel]

Thank you... Glad you're finding the videos useful :)

[@alfredtolaget9101]

Thank you so much, quality and well explained. very much appreciated.

[@georgekhaba6436]

time table : @2:24 creating a new word document using VBA library (early binding ) @5:18 creating a new word document using VBA create object (late binding) @7:44 steps of copying excel table to word using VBA @8:25 using the statement "with" to active multiple commands @9:51 using "with" statement to control the formatting of the text copied to word @12:36 copying the table to word @14:04 saving and exit the document (attention it will override the file with the same name ) @17:19 saving multiple document @19:25 taking the name of the sheet to name the automated word report @20:37 how to exit the word file after creating it @22:31 changing early binding to late binding ( assuming the other users don't have any VBA library )

[@mangobrother]

Thank you. One of the best tutorials I have encountered. I very much like the way you teach sir.

[@trumpexcel]

Glad you found the tutorial useful :)

[@cs-study-ua]

Super cool video & clear explanation

[@anonymousx589]

Fantastic explanation, Thank you!

[@juanpabloserranorubio3876]

exactly what was searching for work

[@tessabio679]

thanks so much, very helpful !!!

[@booksalvation2025]

thank you for a great start to my problem, I my case I have a java app the creates excel sheets but need to print it out in word. And currently do a lot of manual copy and pasting so looks like I should be able to do away with that thanks to your wonderful demo

[@explainedout]

Great video!! Keep going, I am sure your channel will scale very soon!!

[@nicopicco]

What a great video, thank you.

[@TheMisiekMisiek]

Perfect! Very useful.

[@p2kc1]

Thank you for this tutorial Is it possible to save the file automatically with a specified name instead of document1? Cheers

[@soothingrelaxation4161]

Thank you very much for this free tuto. Please, can you tell me if it's possible to generate more than one sheet in the same report?

[@KrashNav]

Way to teach!

[@prediction2302]

Excellent 👌

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@onedaytradingcrypto2758]

Nice tutorial .I like to learn this.

[@malap123]

This is good. Can u read data from csv or text file and insert chart of that?

[@AbedulmajidAlshraidehChannel]

Great job. useful information. however, i have a question on how to select multiple tables in the range. I have multiple tables beneath each other. how to select them all instead of one (end of the 1st one).

[@avijitnov]

WoW!!

[@reviewsfixeshacksmunsur3805]

Hi, how would I use vba coding to to convert information on student subject progress to individual student reports saved in word.

[@shljain]

Hey, i’m trying to paste the table with long data into word doc using excel macro, it’s getting distributed across word doc, could u please assist? Could you please show us how to add the excel workbook at selected location in word?

[@rajeshshah6758]

Sumeet, Is it possible to do the same with notepad.? I want my data copied from excel to notepad.

[@sallu21m]

will there be a requirement to transfer the word template in the same file path if we share the Excel file with other PC ???

[@abdulhamidalhaddadi2255]

Great, this topic close to what I am looking for: "I would like to use this feature in a different way. I have a set of records in the Excel sheet file, and each record carries a number, date, subject and other information, and I would like to create a Word document with the record number and date which I select it only". May I have a questions: 1. How can I make a command bottom for each record to run this code instead to open VBA screen? 2. In your example I want to copy Region in first line, and Sales in second line. I am waiting your reply sir. Thank you

[@limitone9564]

I like your style of explaining things... can you explain how to do the vba code for extracting data by Date? for example, Excel has to sort data by Date (date today, date tomorrow, etc) then extract it to Word by Dept, say Engineering Dept has 5 people coming in today, then Sales Dept has 8 people coming in today, etc... then generate a/one Word report per day/date with all the following data on one sheet: Name, Phone and Notes. Can you help?

[@hajajahirhussain6814]

Need video for outlook also. How to send a mail from vba?

[@rameshthangaraj6590]

How to add table autofit in the modules

[@Ian_Enterprise]

Hello, Great tutorial But i don't get the correct data from my range I use this lastrw = Sheet1.Range("Z99999").End(xlUp).Row Sheet1.Range("Z3:AC" & lastrw).End(xlDown).End(xlToLeft).Copy But i get result from Row F ?? How can i get the results from any range i want.. Could you helpme please Thank you

[@kittyhui347]

Why I cannot auto save as new docx file?

[@mikelennon1078]

Does anyone knows how to simultaneously export all VBA Codes of a workbook into a word document without missing any Modules, Macros, etc contents?

[@suribhandari1985]

Hi Sir - it not working in office 365. Kindly assist...