How to Write on Word from Excel using VBA

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?

Nice

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.

Thank you so much

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.

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

Why mix early binding synthax with the late binding one?

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

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

Super cool! Thank you!

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

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

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

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?

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

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

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

can be used for 1 sheet

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.

Thanks very much cara

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!

How can i do for save the Document ?

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

Very good

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

Thanks for the video. Very useful

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.

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.

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

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

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?

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.

How can I get this example files...?

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

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?

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.

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

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

can i have wirtten manual..

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!

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!

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 

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!

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!

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

Thank you so much. It really helped me a lot

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