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 👍 👍
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 )
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!!
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
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).
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
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?
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?
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...
How to autofit excel table in word using your modules
Your teaching is very clear. So nice of you.
Thank you... Glad you're finding the videos useful :)
Thank you so much, quality and well explained. very much appreciated.
First macro I've ever written and it works really well. Many thanks for this clearly explained tutorial.
Super cool video & clear explanation
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 👍 👍
Fantastic explanation, Thank you!
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 )
Thank you. One of the best tutorials I have encountered. I very much like the way you teach sir.
Glad you found the tutorial useful :)
Great video!! Keep going, I am sure your channel will scale very soon!!
Perfect! Very useful.
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!!
AMAZING!!! 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 ???
exactly what was searching for work
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
What a great video, thank you.
Nice tutorial .I like to learn this.
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?
thanks so much, very helpful !!!
Thank you for this tutorial
Is it possible to save the file automatically with a specified name instead of document1?
Cheers
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).
Thanks so much.
This is good. Can u read data from csv or text file and insert chart of that?
Excellent 👌
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
Hi, how would I use vba coding to to convert information on student subject progress to individual student reports saved in word.
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?
Need video for outlook also.
How to send a mail from vba?
Way to teach!
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?
Sumeet, Is it possible to do the same with notepad.? I want my data copied from excel to notepad.
Why I cannot auto save as new docx file?
How to add table autofit in the modules
Hi Sir - it not working in office 365. Kindly assist...
WoW!!
Does anyone knows how to simultaneously export all VBA Codes of a workbook into a word document without missing any Modules, Macros, etc contents?