How to Write on Word from Excel using VBA

[@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

[@matthewross7850]

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

[@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?

[@akshitjain5780]

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

[@ExcelVbaIsFun]

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

[@p2kc1]

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

[@ExcelForFreelancers]

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

[@abdulhamidalhaddadi2255]

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.

[@mgrinnan01]

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

[@loveg8202]

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

[@josebetancourt5890]

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

[@nikhilsonkar3936]

If i have a word form that i want to fill up using data in excel sheet.. can that be done?

[@andrewhubler8397]

is there a way to insert data from pre-existing cells in Microsoft excel into certain cells of a pre-existing table in MS Word

[@moisesherrera991]

Hey!@ Thank you for this tutorial it has helped so much. Is there anyway to run this vba so that the information you want automatically transferred from excel sheet, goes to a preexisting word document that has a letterhead???

[@ExcelVbaIsFun]

I'm making you a video to answer some of these questions this evening. Hope you like! Dan

[@coreyterry900]

Hi. Is there a way to create several tables in excel and then import them into word using mail merge. So each table imported would be based on the page in mail merge?

[@RAOROCKSTAR1990]

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

[@Berita--Terkini]

can be used for 1 sheet

[@exroyal6262]

Hello , I have one question. I did a word file and I used developer and I want to use the protect form. Until here everything is OK but in my word file, there are some graphics. I want to enter some date into the graphic to change the figures (Sales Amounts) however because I used protect form , I am unable to change the graphics. " I can unprotect and change the graphic however my employee will use this form and thats why ı am protecting it. Is there any way you can help me ? I hope I express myself well. Thanks

[@alextzamtzis5167]

Thanks for the video, Is there any why to insert a whole table instead of one cell? I tried to use Range("A2:C5") after insertafter but I get errors.

[@sant0sch]

I used something like "Worksheets("Sheet1").UsedRange.Copy"

[@ExcelVbaIsFun]

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

[@ZRBBL]

Hello! I got an Excel function which ConvertNumToWords, May I exceute it in Word, so that I get the numbers in words right in the Word document? Thank you for share. Blessings!

[@bondniko]

Why mix early binding synthax with the late binding one?

[@calmvolatility2787]

Super cool! Thank you!

[@krn14242]

Nice job Dan. Sound quality much better now. Did you move your mic?

[@cuneytozkurt4867]

hi, how can you change insertafter range("a1") font style?

[@anupammandal2697]

I work for JP Morgan Chase accounts payable team and we daily come across lots of payment transactions. These transaction information come via email in .txt format as an attachment. Currently we open these emails manually and then copy paste the data into excel. Is there any way to import these transactions detail directly from my inbox in to excel. Regards Anupam M.

[@MohAboAbdo]

Thank you so much

[@Phoenix-ry8hq]

i need to get something similar for Office 2001 for MAC. need EXCELL sheet converted to WORD for easy read. each row with many collums in excel has various txt data. i need each row to be converted into 1 word document so it’s easy to read. what would you charge? can you make that work in office 2011 for mac?

[@ExcelVbaIsFun]

Anupam, Sorry, I'm sooooo 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

[@AlexanderWDI]

Is there a way to export a cell (from excel) as a string to a word document at a specific spot within a body of text in the word document. Thank you.

[@ExcelVbaIsFun]

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

[@kadir_keles]

Hey there! A quick question: Is there a way to save the file as docx, together with pdf? I want to have the pdf version of the document as well. Thanks!

[@ExcelVbaIsFun]

Kadir 'Keleş I would think that this is very possible. You'll have to look at the syntax with which we save documents in word vba or excel to vba.

[@kadir_keles]

ExcelVbaIsFun Ill consider that, and thank you very much for these really useful tutorials!

[@ExcelVbaIsFun]

Cool! You're so welcome!

[@Axmoon1]

I've done what you told. Unfortunately, my problem is way more complex. I've chaged the matrice so that the text is copied only If it has already been chosen by one of many CheckBoxes previously. The thing is, I cannot add 2 texts one after an other. The matrice stops at the second "Dim wApp As Word.Application" , meaning that this word application has already been launched, so I cannot ad anything to it. Could I put this line at last so that it opens only after every text is selected?

[@saikumargaddam302]

Cheers mate.I like your explanation.You build it from scratch. :)

[@ignacio4535]

Hello and thank you! I was just wondering, this would be useful to create letters in Word from Excel, so, how can I create spaces so that the content of other cells be inserted in the write place of the letter, for example; Date, Introduction, recipients name, and final comments, signature, thank you!

[@algamdie]

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

[@ExcelVbaIsFun]

Thank you so much!👍

[@jorge.mpjunior]

What version of Excel are you using? I asked because of this error "Dim wrdApp As Word.Application" and I think its happens for this cause (version of Office. PS: I'm sorry for my english, I'm a brazilian!

[@ExcelVbaIsFun]

Jorge Pereira I used 2010 in this vid but I now have 2013. Thanks, Dan

[@redlady120]

hi there. hope you guys can help out. it's a similar situation in a userform in excel. i'd like to know how to add a text box wherein selected labels will appear with entered data in it. sort of like a summary of what you've entered to appear in a box in the same excel sheet. also, how do I add a time start-time start function button in excel userform. thanks a bunch.

[@wojciech765]

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.

[@ExcelVbaIsFun]

I'm making you a video to answer some of these questions this evening. Hope you like! Dan

[@davide.i]

Hello! I have a Worksheet of Excel 2010 with several numbers (for example from A1 to A5) and a cell with the sum (A6) I want to link the number of the sum to Word 2010. I want to write, for example: "The sum of 2014 is " and add the information from excel. It could be as if I have a phrase with a field in the middle of it. The number of this field should change automatically if I change the numbers in Excel. Is it possible for you by VBA? I tried the "Past Special" But i can't "move" the pasted field as I want. Could you tell me what I should do for my goal? Thank you very much!

[@ExcelVbaIsFun]

making a video for you now on this topic of find and replace in excel vba to word, my friend. Dan

[@ExcelVbaIsFun]

Davide I video is here Excel to Word pt 3 Find AND Replace in Word from Excel VBA for you. Dan

[@davide.i]

ExcelVbaIsFun Thank you very much. I think your work is very great. I must improve my english so I'll be able to understand your videos better (I'm italian). I think this programs are very powerful!

[@anupammandal2697]

Hello Again Dan, Is there any way to import data from outlook to an Excel ? This will help me alot !! Thanks in advance. Anupam

[@nileshtikekar3235]

Thanks for the video. Very useful

[@ExcelVbaIsFun]

You're so welcome. Thanks for the comment!

[@jai5295]

Hi, how can we edit the letter templete in excel using vba

[@kittyswain-evans6867]

First off let me say I am experienced with Excel but a real VBA newbie. I am playing with the function to add cell information to a Word document. Unfortunately I cannot get past the first "Set" to Create my Word Application Object. Since I am a newbie, I am sure I am missing something very simple. Dim wApp As Word.Application Dim wDoc As Word.Document Set wApp = CreateObject(Word.Application) wApp.Visible = True When I run this I get the following error: Run-time error '429': ActiveX component can't create object I would appreciate any help I can get. Thanks.

[@BayOrca]

A little late but: CreateObject("Word.Application") (with quotation mark) should help or: Set wApp = New Word.Application (If you have the Microsoft Word reference added)

[@mitchellhailey2333]

Wondering if anyone knows any way to speed up the process copy and paste paperwork? For work, I have forms that are a pape long that have to be created for around 30 different companies. The forms are all the same except for a few differences such as company names and addresses. The current way we do it is by having a template document and then typing or copy and paste in the needed information. This process can take a couple hours and I'm sure there's a better way to do it. The goal would be to have one document in excel that I could go in and list all the company's information and then it would automatically generate the needed documents. There's got to be a way to do it I just can't figure it out any help would be greatly appreciated.

[@luizeduardo5786]

How can i do for save the Document ?

[@excelisfun]

Thanks for the video!

[@hudsonwells9472]

i guess I am kinda randomly asking but does anyone know a good site to stream newly released series online ?

[@ExcelVbaIsFun]

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

[@sunilsuwal4812]

How can I get this example files...?

[@MohammadTaha]

Good, I want to write to word from excel but I want to create a table this time with data in it and further yet, I want to write to a word template rather than to fresh word document. is that possible?

[@ExcelVbaIsFun]

I'm making you a video to answer some of these questions this evening. Hope you like! Dan

[@MohammadTaha]

I'll be waiting Dan, thank you in advance

[@ExcelVbaIsFun]

Mohammad Taha Excel In Excel Here it is once it's done uploading. kzbin.info/www/bejne/r3uph4elqpiEf8k

[@MohammadTaha]

Highly appreciated Monsieur Dan, I am waiting for it, Merci

[@ExcelVbaIsFun]

you're welcome. It's available now. here kzbin.info/www/bejne/r3uph4elqpiEf8k

[@zachariahprince08]

Thank you so much. It really helped me a lot

[@ExcelVbaIsFun]

You're very welcome! prince zachariah more tips on my new ebook www.excelvbaisfun.com/free-ebook.html Blessings!, Dan

[@mikelennon1078]

Anyone knows how to export /save all of Macros/Modules form a workbook (globally) into a word document without missing any VBA codes?

[@Sobolev514]

Thanks a lot for this great effort.

[@anupammandal2697]

I'm so damn excited !! Thanks in advance Dan

[@matheusreges6056]

Thanks very much cara

[@ExcelVbaIsFun]

Thanks sobolev, I hope it's helpful! Dan

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

[@nitishabikoo4425]

hello i have a company where we give some courses n certificate of attendance. its very time consuming do the certificate of attendance for hundred of participants, i copy n paste the names. Is there any other automatic ways i can do it faster? Thank you very much

[@ericprobinson]

yes

[@ExcelVbaIsFun]

Thanks!!

[@richardburbank7830]

Nice. Thanks for the explanation.

[@ExcelVbaIsFun]

thanks! I'm making a "Part 2" tonight about navigation and editing, as well as opening an existing Word Document.

[@DatabaseDesigns4U]

Wow! Fun stuff! :) Snap! :) I love it! Thanks for sharing. :)

[@ExcelVbaIsFun]

You're welcome. Thanks DatabaseDesigns4U

[@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

[@ajayasdfasdf]

CreateObject function is not working MsOffice 2007

[@gexcel]

Good video!

[@thorngbun7084]

Very good

[@alondrabelemmoralesplata2308]

well and what instruction or command to save the document as Word or PDF excel macro ??? that I have a macro that generates the Word document from a template and not save the document as generating :( can you help meeee pleaseeeeeee :'( ExcelVbaIsFun

[@jennamccallon4850]

did you get an answer for this? I am trying to do the same thing right now!

[@shaynasapri5850]

can i have wirtten manual..

[@markangeloreyes4578]

Nice

[@ExcelVbaIsFun]

uploading now, sir. Dan

[@ExcelVbaIsFun]

yes, I experimented. The mike must (for whatever reason) be up near my nose. It doesn't catch my nose sounds, just talking. nose sounds (lol). just sounds funny. Dan

[@ExcelVbaIsFun]

lol, thanks!

[@sainiprintingpress6607]

there is mistake, Hundred is coming two times, first should be lakh

[@ExcelVbaIsFun]

Hi saini, Just rewatched the vid. I don't see hundred. Thanks

[@Almost_Forgotten_Films]

Constructive criticism: It would be a good idea to practice and get the procedures down before making a KZbin video. It's awkward watching you struggle to remember how to do something.