Be the first user to complete this post
|
Add to List |
VBA-Excel: Create a new Word Document
For creating a new Microsoft Word Document using Microsoft Excel, you need to follow the steps below:
- Create the object of Microsoft Word
- Add documents to the Word
- Make the MS Word visible
Create the object of Microsoft Word
Set objWord = CreateObject(“Word.Application”)
Add documents to the Word
Set objDoc = objWord.Documents.Add
Make the MS Word Visible
objWord.Visible = True
Complete Code:
Function FnCreateWordDoc() Dim objWord Dim objDoc Set objWord = CreateObject("Word.Application") Set objDoc = objWord.Documents.Add objWord.Visible = True End Function
Also Read:
- VBA-Excel: Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel.
- VBA-Excel: Working with Bookmarks- Insert text After Bookmark
- VBA-Excel: Writing Text to Word document
- VBA-Excel: Format the Existing Table in a Word document
- VBA-Excel: Read Data from XML File