Excel VBA Introduction Part 27.1 - Creating Word Documents

Подписаться 207 тыс.

Просмотров 175 тыс.

50% 1

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!
You can buy our Introduction to Excel VBA book here www.lulu.com/shop/andrew-goul...
By Andrew Gould
www.wiseowl.co.uk - Writing VBA code in Excel doesn't only allow you to control Excel, you also have access to all of the other Office applications. This video looks at how to control Microsoft Word by writing code in Excel. You'll learn how to reference the Word Object Library, several methods for creating a new instance of the Word application, how to create new documents and how to copy data from Excel into Word. You'll also learn the importance of testing for which version of Word your users are running and how to write version-independent code that will work with (almost) any version of Word.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

Опубликовано:

5 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 230

@ShineWarrior 2 года назад

Man, I have no words, your video is the best guide of VBA I've ever seen, you're a great teacher! Thank you so much

@WiseOwlTutorials 2 года назад

Ah thank you Bruno, I really appreciate that!

@itsdaj Год назад

I would give this 5 likes if I could. Not only is this great material, but it is also worth studying. There are so many tips and answers here. Your level of explanation is perfect.

@WiseOwlTutorials Год назад

Thanks so much!

@jam92es 6 лет назад

This is absolutely brilliant! Thank you so much for the video, you walked through everything so well and covered so many great scenarios. Thank you!

@DavidAYork 6 лет назад

Thank you for all the videos you've produced. They have taken me a long way from "novice" to producing outstanding content in a very short period of time. I like the speed you go at (I can always step back if I need to) because the amount of information is incredible. I LEARN from your videos. Thank you!

@tajsay 4 года назад

You are simply brilliant Andrew. I haven't left with any words to thank you. I am just addicted to your videos.

@nurlankalybekov7336 8 лет назад

Hardworking in commenting and Simple. My raise hand. Thank you

@CyrusPieris 4 года назад

You are just amazing. I am actually learning computer programming via all the courses you are presenting. I will be making a donation as you are really helping me out in my career! thank you so much Andrew. Also the book you have written is amazing. I think it is the go to guide for VBA.

@ledfootdude 8 лет назад

AMAZING, just came across your video and I have to say I don't think anyone could have done a better job. It's amazing how much depth you provide, along with making it simple to understand. LOVE IT!!! Thank you

@watcherRA 8 лет назад

Another smashing hit! Your videos are top quality, your explanations are clear, your examples are focused, and your coverage of the issues is comprehensive. Your RU-vid channel is a treasure trove, nothing less. Thank you for doing this!

@samouhi 6 лет назад

I second watcherRA. Thank you so much for the effort you put into these tutorials and being so generous with your tips and details.

@maurocastagnera8949 6 лет назад

Dear Andrew, it's a pleasure to watch your videos! You have the great ability to be essential, but at the same time do not overlook any detail you need to understand exactly how the program works. Really at any time of the day I watch your lessons, even after a hard day's work. I really believe that you are a very intelligent person and also admirable for having made available to all your innate professional and teaching skills. Thank you not just for the VBA, as at the same time I'm also improving my English. I do not know if and when I can visit England, but I would be extremely pleased to congratulate you on getting to know you personally. Who knows ... maybe one day we will meet. Thank you very much.

@isabellal.1727 6 лет назад

Extremely detailed and easy to understand, this video is more helpful than the VBA courses I've had before, thank you so much.

@oz7075 7 лет назад

What a great video, just as the rest of them on your channel. I'd like to thank you for sharing your knowledge and give thorough explanations which is what I usually look for, not simply being given the right instructions to use. One of the things I struggled most with was the use of the CreateObject or Set...New. I saw them used many times but I couldn't tell the difference. Now it's pretty clear what they're for and the advantages and disadvantages of using one option or the other. Superb work :)

@jmathew6988 2 года назад

This tutorial stands out among all other RU-vid videos discussing the topic Excel VBA - Word. Thanks Andrew.

@WiseOwlTutorials 2 года назад

Thank you for the kind words!

@MrDontuknowme 4 года назад

This is a beautifully made tutorial. You are amazingly knowledgeable and are fantastic at conveying that knowledge. Thank YOU!

@WiseOwlTutorials 4 года назад

Thank you! Happy to hear that you enjoyed the video and thank you for taking the time to leave such a nice comment!

@renayi2842 5 лет назад

Absolutely wonderful! Simple, informative, easy to follow. Thank you!!

@DineshKumar-lq2ck 3 года назад

You are making life easier for many like me. You will definitely be blessed.

@WiseOwlTutorials 3 года назад

Thank you Dinesh!

@totalzack5000 7 лет назад

Hi, I want to thank you for all of your great videos on vba. I've got a lot of help over the last years from you and, I LOVE the way you say "reference". Please throw more references in there and keep up the good work

@Joni67sinix 5 лет назад

best tutorial i ever seen in my life. congrats bro!!!!

@88Nateg 9 лет назад

Brilliant tutorial thanks! I keep referring back to this vid and it's always a huge help!

@divyal5852 8 лет назад

Hi Andrew, thank you so much! Amazing video seen so far!

@Piplodocus 5 лет назад

I needed to know what was in the title of the video. The last few days and in future though I've needed to know all the tons of other useful stuff in here too! Great vid. :)

@yacinelimane2011 2 года назад

Exactly what I was looking for, you are amazing, and a great teacher as well, God bless you.

@WiseOwlTutorials 2 года назад

Thank you so much, I'm glad that you found the video useful!

@arkadyvoloshin6413 4 года назад

Great tutorial, best I was able to find.

@WiseOwlTutorials 4 года назад

Thank you Arkady!

@augustodemelo915 4 года назад

Excellent video. Great didactic technic. Congratulations! I cannot understand how someone can give a thumbs down for this excellent tutorial. For sure these people have a problem, I am sorry! Go ahead and bring us great things like this.

@ankurverma3638 Год назад

you are the greatest VBA teacher

@WiseOwlTutorials Год назад

Thank you Ankur!

@musimuvi1916 7 лет назад

Excellent video. I normally don't "like" any videos on youtube but I HAD to like, comment and subscribe to this one. You mastery of VBA is great, you presentation skills are on point and the content is super relevant. Well done!

@dadz1299 8 лет назад

Dear Andrew, THANKS A LOT !!! Your video are very useful.

@kapibara2440 Год назад

This is a brilliant video! Thank you Wise Owl ❤

@WiseOwlTutorials Год назад

Thanks for watching!

@MrRusseltjj 9 лет назад

Thank you so much, my code works perfectly now!

@pyerenee1 Год назад

Thank you so much! Exactly what I was looking for. Moreover, the entire series of videos is very interesting and useful. Also, you are a very good teacher. Thanks again!

@WiseOwlTutorials Год назад

Happy to hear that you found it useful, thanks for watching!

@maurocastagnera8949 5 лет назад

You are a genius! No other words are needed!

@ankurverma3638 Год назад

so patient and the explanation to everything is meaningful and explains the how and why

@WiseOwlTutorials Год назад

Happy to hear that you found it useful! Thanks for watching and for leaving a comment!

@chrisgray8774 11 месяцев назад

Even my Word 2016 is outdated by now, but your techniques still apply. Thank you for your help.

@WiseOwlTutorials 10 месяцев назад

Thanks Chris, happy to hear you found it useful!

@mytedico 2 года назад

Sir, From the start, to end this video is really worthful to watch, thank you for such an excellent video.

@WiseOwlTutorials 2 года назад

You're very welcome, thank you for the comment!

@vijaykumar-gv1dg 4 года назад

You are simply amazing.....thank you very much for the videos. Very helpful for a beginner like me.

@peterhontaru5537 6 лет назад

Fantastic lesson - thank you very much!!!

@fekrabusinesssolutions 2 года назад

Thank you sir, this is very helpful. Even after getting my answers, I wanted to continue watching because it is a valuable content.

@WiseOwlTutorials 2 года назад

Happy to hear that you enjoyed it, thanks for watching!

@sachinkathpalia 7 лет назад

thank you for very detailed and informative tutorial.

@renebehr5785 8 лет назад

Hi Andrew, thanks for the video.

@Trucpq 3 дня назад

So helpful and excelent explanation !

@PFCMCS 7 лет назад

Excellent video, very clear explainations

@ec_789 9 лет назад

Thank you very much for your awesome videos

@AspullSpasandPools 9 лет назад

Thank you very much the best tutorial i have see on the net

@VictorKap Год назад

Brilliant, love your work. Thank you

@WiseOwlTutorials Год назад

Thanks Victor!

@marcip1456 7 лет назад

I don't understand how you get any bad ratings on these videos. They are so amazing. Thanks again!

@user-iv8en3rv7m 7 месяцев назад

Great work! Thank you for this greate tutorial!

@WiseOwlTutorials 7 месяцев назад

Thank you so much for watching!

@Chris_in_fremantle 7 лет назад

Excellent tutorial.

@watawonderfulworld 6 лет назад

just toooooo good... thanks a lot for sharing

@adriancelis9691 5 лет назад

Great explanation. Thanks!

@WiseOwlTutorials 5 лет назад

You're welcome, Adrian, thanks for watching!

@parikshitpadture4122 4 года назад

Thanks Andrew for the useful video

@WiseOwlTutorials 4 года назад

You're welcome, Parikshit, thank you for watching!

@makifguzey 7 лет назад

Thanks a lot, great video.

@KM-co5mx 2 года назад

This is Awesome! and You're Awesome! 🙇‍♂

@WiseOwlTutorials 2 года назад

Ahh thanks! 😀

@scotolivera8207 4 года назад

thank you, sir for this well-designed tutorial, What about MS access, are you planning for making a tutorial for it too?

@healerca 7 лет назад

Great video. Thank-you very much

@cristoumanzor3896 4 года назад

Great lecture!

@engenheiromalucoo.o2576 5 лет назад

This guy is the best!

@victoropere2107 6 лет назад

simply amazing

@Princessels1331 6 лет назад

Thank you... very interesting.

@patricknyamu6110 10 лет назад

Wonderful!!! thanks

@KawanExcel 2 года назад

This is so much.... Thanks Andrew

@WiseOwlTutorials 2 года назад

You're very welcome! Glad you enjoyed this video too and thank you for watching!

@thinkandchangethewayyouthi9142 5 лет назад

Thanks , Perfect way of exlpanation

@WiseOwlTutorials 5 лет назад

You're very welcome, thank you for the comment!

@Rebel36X 6 лет назад

Excellent Video! Just wondering if I can SaveAs my document using data from a cell in my document title?

@chathurathilakarathne2205 4 года назад

That's bloody beautiful

@WiseOwlTutorials 4 года назад

Thanks, glad you liked it!

@ssa1632 4 года назад

Thank you so much! Superb! Would u please guide me the code for making two pages in word documents for two separate ranges in Excel!

@shaunmaher278 9 лет назад

Hello, thanks very much for the video. How can you save the Word document with a unique name, thats perhaps references a cell in the Excel Worksheet?

@glennlaanekorb9168 4 года назад

Well explained video and was super easy to follow. How would you take cells out of the excel table and insert into word document in a custom table that is created with VBA code?

@ricardobrizuela7589 7 лет назад

awesome video!

@mickcarroll1 9 лет назад

Hi Andrew, yours are the best delivered tutorials on RU-vid bar none. I'm less than a newbie in VBA and may have missed this but is there a way of personalising each email - e.g. "Hi ,"? while still adding attachments?

@abdullahquhtani4247 6 лет назад

One more question plz, what if I want to save the document as PDF instead of .doc or .docx? Thank you.

@jordanjvansickle 7 лет назад

This is great! How can I get my data to automatically scale to fit the word document? The data in Excel fits within the page guidelines, but it does not when I transfer it to Word.

@ondrakvratislav 7 лет назад

Amazing techniques of the tutor. Very well prepared

@kristiandadhley977 7 лет назад

Great Vid! Would a similar thing be done if you wanted to populate a word report with data from excel. i.e. you had a standard MS word report that said something like. "Since the last report X people have signed up with the company and Y people have retired" where you want to populate the X and Y with values from an excel sheet?

@fabianreurekas9996 3 года назад

Thank you very much!

@WiseOwlTutorials 3 года назад

You're very welcome Fabian, thank you for watching!

@CallipygianMoose 4 года назад

great video and it works perfectly so thanks! I would like to add something else to this but I'm not sure how....> my table that I am importing to word has some cells that contain formulas that are returning null-strings. Unfortunately when the table is imported to word it imports the blank rows. I could of course just delete them after they have been imported, however I thought Id ask if there was a way using VBA code when selecting the columns to be sent to word, to ignore all cells containing null-strings? currently i could have values on row a, nothing on row b, values on row c etc in any order. I only want VBA to take data from the table of values that contains a value, and I do not want gaps between. I dont necesarily want to remove the formula or the null-string from the Excel document its self, I just want it to ignore those cells when exporting and sort it in such a way that there are no gaps where nullstrings would have been.

@martinvarela206 7 лет назад

Hi!, there are any chances that you make a tutorial or at least offer a link about manipulate style list from excel vba, with data (like items, if they use number or dots, the level of the item) on a table, for give format in word?

@dksuthar31 Год назад

thank you wise owl

@WiseOwlTutorials Год назад

You're welcome Deepak, thanks for watching!

@droidgenetx 5 лет назад

thank you!

@chriscook4076 9 лет назад

Hello Andrew. Thanks for the great video tutorial! I was hoping that you might post a video (or perhaps reply with the code) to copy only specific cells from excel to the bookmarks in word. In my job I put together contracts that have repetitive information and I wanted to put together a one page "Questionnaire" (for lack of a better term) to inject the "answers" into whichever page of the word doc it relates to using the bookmark method. Any help or suggestions is greatly appreciated!

@jujutheplayer 9 лет назад

That helped me a lot thanks :-) !

@jujutheplayer 9 лет назад

***** I ran into trouble recently, I'm trying to insert a word table to a bookmark location but sadly I can't get it working :-( I'd be very thankful if you could help me :-)

@cekinci 8 лет назад

Hi Andrew, first I would like to say your videos are great, and can't believe this to be free!! Anyways, I would like to know if I could edit a word file like a contract, and change the data within using my excel worksheet. For instance, I only use "find-replace" to edit manually, but I would like to automate it if possible?

@freebeatingheart3006 9 лет назад

Thanks for this excellent tutorial. How can the cell heights and widths be retained when copied over to Word?

@freebeatingheart3006 8 лет назад

+WiseOwlTutorials Thanks. With a slight tweek I used: Range("A1", "I56").CopyPicture wdapp.Selection.Paste "Current region" seems to select one cell only.

@retrofutur1st 3 года назад

Thank you!!!!

@WiseOwlTutorials 3 года назад

You're welcome!

@joncroweucl 7 лет назад

Thank you for the excellent video. I can paste data into bookmarks and am using .Selection.PasteSpecial DataType:=wdPasteText so the information within cells is pasted as text at the bookmark location within a paragraph. However, doing so removes the bookmark and the reference for subsequent cross-referenced text. How can I paste data from Excel into Bookmarks in Word and still retain the bookmark for cross-referencing? Thanks again :)

@naelsajim7383 9 лет назад

Thank you for this great video Andrew. i wanted to ask if it is possible to create a word doc automatically after entering every individual data so that it belongs to that certain individual ,and it will contain for example certain cells only like (name and age for example) an individual word file to every person in excel table in order to edit it later and enter detailed info as word docs

@naelsajim7383 9 лет назад

***** thank you for the reply Andrew ,i want to ask you about an exe application that opens the same word template and adds only certain data directly from that template after editing (for example name and date ) to an excel sheet for easy searching.i have that exe application and want to show it to you,in order to understand how it works ,if that is ok please tell how to contact

@Mugichwan 9 лет назад

Dear Andrew Thank you very much for these amazing and resourceful VBA tutorials. How do you reference bookmarks located in the footer/header of a word document from excel? I tried to paste data in the footer section of a word document by referring to the bookmark as you would if it was in the main document but got a runtime error: "Word cannot find the requested bookmark" Thanks David

@Mugichwan 9 лет назад

***** Hi Andrew, That sure helped. My code is now working properly. Thank you very much!

@julianevans2256 Год назад

Awesome tutorial, I've known about early and late binding for years without really understanding it? this has explained it really well

@WiseOwlTutorials Год назад

Thanks Julian, happy to hear that it helped!

@MonikaR2006 5 лет назад

Thank you very much for this very well explained tutorial. I seem to have an issue with selecting the range I want to use. Copying your example, I get an error message and nothing is displayed (Range("A2", Range("A2").End(x1Down).End(x1ToRight)).Copy). In fact in may case, I would like to have the range start at A2 - down - to I and down. Perhaps this is not something to be solved just via this message?

@fakename6300 4 года назад

Syntax should be; Range("A2", Range("A2").End(xlDown).End(xlToRight)).Copy 1's should be l's

@kirayamatofication 10 лет назад

This is really a big help explaining pulling a microsoft application from another. But do you have videos running VBA with outlook as the main application and running excel then after using outlook codes?

@kirayamatofication 9 лет назад

Ah... This will come handy. Thanks a bunch!

@abheetkansal3790 2 года назад

Great walkthrough! I wanted to ask what if I have an excel sheet and want to generate a word document which is a form but want somethings autofilled from that excel row. The main issue I am facing is how to fit that excel data in that row from cells to particular places in my form Any ideas??

@WiseOwlTutorials 2 года назад

Hi! You can use bookmarks in the Word document and apply the GoTo method to select them docs.microsoft.com/en-us/office/vba/api/word.selection.goto There's some basic sample code here stackoverflow.com/questions/2725550/how-to-jump-to-a-bookmark-in-word-vba-and-insert-text I hope it helps!

@arvindkumarauro9731 2 года назад

Thanks a ton sir 😘

@WiseOwlTutorials 2 года назад

You're very welcome Arvind!

@kevink8248 8 лет назад

Great video series Andrew thank you . Curious if you could explain how I could reference an embedded Word Template (in same excel file) instead of referencing the file path as you have done in the video with the .Documents.Add. Want to distribute the Excel file with the template embedded instead of having to access users file structure. Any insight is much appreciated.

@kevink8248 8 лет назад

+WiseOwlTutorials Greatly appreciated will give it a shot

@sandicanales8081 8 лет назад

Hi there, thus far WiseOwlTutorials are the best from all other tutorials I've watched to learn using VBA. I need help on something I'm sure is easy for you. I have an excel sheet with word information across in different cells. I simple need to structure a module that exports it all into a word document vertically using groups of cell aligned below each other like a paragraph. What are the codes i need to organize each cell. Do I have to set bookmarks (I don't even know what that is). Your guidance is greatly appreciated. Thank you.

@TheFikaky 8 лет назад

Hi Andrew, thanks for another great video..I copied your code, but it doesn't work if I enter numbers with the if statement (if .version

@RamboRoberto2905 4 года назад

Hello: please advise how to center a text vertically (as Page Setup/Layout/Page/Center). Also, please advise how to enter a new page in the created word document (as page break). In your video you showed how to enter a new line (with .TypeText vbnewline) or new paragraph (.Typeparagraph). Thank you.

@91alezander 4 года назад

It is possible to generate a word template from every excel row individually. In excel I need a button to appear on every new row I populate with data and the button must open the word template that was fill with the data that I populate the row. And also i need the autofill word template to be save in a specified location. Thank you!

@nishchaynagpal6051 7 лет назад

Hi, I had a query. If we use late binding in vba then there is no need for word,outlook,etc. library but when i did that the actions(object.action) that you use in this video gave an error as variable not defined which should not happen, as you said that people tend to program using early binding and then convert later to late binding. The line that gave me the error was '.ParagraphFormat.Alignment = wdAlignParagraphCenter'.

@nishchaynagpal6051 7 лет назад

WiseOwlTutorials I got confused since it was not working. Thanks :)

@drrupeshgupta 9 лет назад

Very nice tutorial… Will like to know if it is possible to export text only from excel to word??

@drrupeshgupta 9 лет назад

***** Hello dear, Can I run it on mac? When I run the script on mac, i get "ActiveX component can't create object error" Any clues?

@m.mohtashim2000 3 года назад

I really appreciate your tutorials Andrew, they helped me learn a lot. One thing I would advise you to do is that get the different sections inside the description box and youtube will create navigation panes for the video and that way it will be easier to navigate to specific sections of tutorials.

@WiseOwlTutorials 3 года назад

Thanks yes, we've been adding chapters to all of the videos we release for the past six months or so. We haven't had the time to go back to the hundreds of older videos to do the same yet! I'm happy to hear that you found the video useful anyway, thank you for watching and for sharing that tip!

@m.mohtashim2000 3 года назад

@@WiseOwlTutorialsOhh I see, I understand it will take quite a long time to do that for each video. Much Appreciated😊

@WiseOwlTutorials 3 года назад

@@m.mohtashim2000 Indeed it will - I wish we hadn't made so many videos now!

@m.mohtashim2000 3 года назад

@@WiseOwlTutorials Can I make a request to you. Can you please make an in-depth tutorial on word macros as well.

@WiseOwlTutorials 3 года назад

@@m.mohtashim2000 Hi there! I don't think it's very likely that we'll have an entire series on Word macros although we will probably have the occasional video involving Word.

@singhdevprashant 4 года назад

Pls suggest VBA code to copy specific selections from one Word file to another, by opening data from one file and copying it to other using VBA. Thanks a lot in advance.

@timcago 10 лет назад

Can you make a video that shows how to pull data from queries in VBA and update sheets in the workbook? In the business world this is what you end up needing to use VBA for most of the time.