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...

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 👍 👍

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!!

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

Fantastic explanation, Thank you!

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

Your teaching is very clear. So nice of you.

Super cool video & clear explanation

thanks so much, very helpful !!!

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

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

What a great video, thank you.

Perfect! Very useful.

Excellent 👌

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?

exactly what was searching for work

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

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

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

Nice tutorial .I like to learn this.

Thanks so much.

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).

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 )

WoW!!

Way to teach!

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

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?

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

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

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

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?

How to add table autofit in the modules

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

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

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

Why I cannot auto save as new docx file?

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