How to Open, Navigate and Edit Existing WORD Doc Using Excel VBA! Comprehensive guide

Here is a huge tutorial on ways to navigate in MS Word through Excel VBA. This is part 2 of the MS Word lessons. In this one, we learn to open an existing word doc and how to find where you need to be and how to add text wherever you need it.

Fantastic Developer Tools:

[goncalomarques]

Bro, you were the only one with a proper tutorial and quality answers.
2 words: Thank You!

[ahmedburo]

Thank u Dan. Its been very stimulating and helpful.

[Zandor]

great video. lots of good ideas. thanks for taking the time.

[moisesherrera]

This is great! thank you so much. has helped so much!

[MohammadTaha]

wonderful, that's a lot of ideas about the subject, thank you Dan

[jamessmyth]

This is incredibly fun; thanks for making this video!

[sandeshrallapalli]

Dan, thanks for all the tips, very helpful for my current project. I was wondering if you had any tips for exporting an entire table from excel into a word doc that already has a template for the table somewhere within the doc

[parthshah]

Great Video. Thanks a lot. Please keep doing such great work.

[jamessmyth]

I made the sickest tool w/ this as inspiration. Generates data w/ granular control, and pushes it into word perfectly formatted. Makes ppl scratch their heads....

[davidspencer-tpkd]

Great Video, Thanks. I'd like to use the find and replace functionality multiple times. i was hoping i could simply copy and paste the code in the example under the current code and change the #5 for a #6 and the cell reference from A6 to another But when i copy the code straight under the current existing code it doesn't work. is there something i need to add between them? Thanks in advance.

[ahmedburo]

Thank you again. Could u please help me on how to write code to initiate table in this particular document. and I don't mean by that copying or exporting an existing table from excel file but rather initiating a new table in ward and adding cells to it . I have used macro in ward to record the code for table but I had a problem to refer to it in the excel file .

[jennamccallon]

Is it possible to embed a word document into excel so that both files could open together with the above macro and be manipulated? I want to be able to send my macro enabled excel sheet, I understand I could place the document on a share drive but I was hoping there was a work around so that others not on the network could access this. I want users to be able to use a button with the attached macro and successfully receive an auto-filled word document that was created with this awesome tool.

[brianmller]

Hi. What is the benefit of using vba in Excel to fill a Word document, rather than using vba in Word itself to do the same work?

[abdulhamidalhaddadi]

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

[shlerTHEnumbas]

what about if you wanted to make text bold?

[marlon]

hi can you help me.. can you make a vba macro tool to take screenshot and paste to word doc and the same time attach files(image, word, excel, pdf) on the same word doc

[michalroesler]

Hello Dan. I'd like to ask what is the difference between Word.Application and Word.Document? If I want to search currently opened word document using vba code run from excel file, do I need to use Word.Application or Word.Document to activate word file to be searched?

[lelandxu]

Do you have any idea about how to link a LINGO10 onto Excel? I've tried inserting an object, but "Lingo Document" wasn't one of the choices I could check off (and according to Google, it should be). How can I make the LINGO10 application an option as a file to open on Excel?

[jessicasummers]

I am trying to download the workbook, but get an error page. I've searched on your site for the workbook and come up with "no results found" message. Any idea where I can get another copy of this?

[traysonrubio]

Does anybody know how I could find a keyword in the text document and replace it with a cell from an excel spreadsheet, and repeat the process for a long column of words?
thanks good video btw!