Free Excel VBA Course #35 - Creating Word Reports Using VBA
HTML-код
- Опубликовано: 23 мар 2020
- 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: ruclips.net/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial
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
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.
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 👍 👍
Your teaching is very clear. So nice of you.
Thank you... Glad you're finding the videos useful :)
Super cool video & clear explanation
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
Fantastic explanation, Thank you!
thanks so much, very helpful !!!
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 :)
What a great video, thank you.
Perfect! Very useful.
Great video!! Keep going, I am sure your channel will scale very soon!!
exactly what was searching for work
Excellent 👌
Thanks so much.
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?
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?
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.
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?
Sumeet, Is it possible to do the same with notepad.? I want my data copied from excel to notepad.
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
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...