How to Write on Word from Excel using VBA

In this lesson, we learn how to add text to a Word document using microsoft excel!
Check it out!

Fantastic Developer Tools:

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[matthewross]

Thank you, been searching for something at a beginner level for a while. Appreciate how slow the video goes. So many videos on YouTube move too quick and try to do too much.

[ExcelVbaIsFun]

Check out part two of this Excel to Word series here: How to Open, Navigate and Edit Existing WORD Doc Using Excel VBA! Comprehensive guide

[algamdie]

Excel vba is not fun . You are the fun one.

[ExcelVbaIsFun]

Mzchkolate1, you're very welcome. Thx for the comments!!

[billithebros]

To do the trick you have to created a reference to the Word type library Go to Tools>References, scroll down to Microsoft Word, and check it.

[loveg]

It's really fun, next time i should use this method to communicate between Excel and Word...

[mgrinnan]

Thanks Dan... EXACTLY what I needed to see. Was a tremendous help!

[ExcelForFreelancers]

Thank's Dan. Love all of your videos :)

[akshitjain]

Thanks buddy for sharing this..can you please suggest how to paste the line in specific line

[ExcelVbaIsFun]

You're very welcome, Sobolev514! Thank for watching and commenting!! Dan

[ExcelVbaIsFun]

I'm not certain, will have to look into this. Dan

[abdulhamidalhaddadi]

Great, I succeed. I like to apply this technic to my work.

i have registration records in excel, and for each record I isseu a letter.

how can I use my last record to my word document automaticly or can I make a drop down list related to excel file to select. if you have any idea.

[josebetancourt]

Love your videos!! It's possible to write a code in which can lookup through folders and subfolders the file names that has been added for example, today?

Thanks a lot!!

[ExcelVbaIsFun]

Maybe. What do you want to import specifically? Thanks, Dan

[ExcelVbaIsFun]

Anupam,

Sorry, I'm behind on my questions in my inbox, but I was able to film a new one for you on importing txt files straight to Excel with lots of side notes and helpful tips. Hope this helps you, should be ready tonight or tomorrow. Blessings, Dan

[wojciech]

it is a good information about export range from Excell to a Word. maybe you can show next step - how export many ranges with for example some view /as one page - from excell to a word. Anyway this wideo is really very good. Thanks for it.

[pkc]

Thank you so much dan that's a saving life tutorial. I have a quetion please!
Can i add an automate fonctionality of the following list in row?
1-Creating file with a specified name from a cell data
2- saving file
3- opening the file
Thanks in advance

[justdoit_leo]

Thanks a lot for video! One question, is it possible to make something like this but to transfer name of every excel sheet to the new word document page?

[RAOROCKSTAR]

What if I want to insert an entire table instead of just one cell? Range isn't working for table (A1:F20 kind of)