MS Word VBA Interview Questions and Answers with Examples

MS Word VBA Interview Questions and Answers explained with Example macros. Here are the list of most frequently asked basic MS Word VBA interview questions. All the questions are answered with simple examples. These questions will help you to answer basic questions to deal with MS Word VBA development.

1. How to create a new word document using VBA?

Here is the following VBA macro to create a new Word document.
‘Create New Word Document

 Sub Create_Documnent()
    Documents.Add
End Sub

2. How to create a new word document from the existing word document using VBA?

Here is the following VBA procedure to create a word document from the existing word documnet

'Create new word document based on existing word document
Sub Create_Doc_ReadOnly()
    Documents.Add Template:="D:/Test.doc", NewTemplate:=True
End Sub

3. How to create a word document as a read only document using VBA?

Here is the following VBA procedure to create a word document as a read only document.

'Open a Existing Word Document (Read Only Document)
Sub Open_Doc_ReadOnly()
    Documents.Open FileName:="D:/Test.doc", ReadOnly:=True
End Sub

4. How to save a word document using VBA?

Here is the following VBA code to save a word document.

 'Save Word Document if already not saved
Sub Save_Documnent()
    If ActiveDocument.Saved = False Then
        ActiveDocument.Save
    End If
End Sub

5. How to SaveAs a word document using VBA?

Here is the following VBA procedure to SaveAs a word document.

'SaveAs Word Document if already not saved
Sub SaveAs_Documnent()
    ActiveDocument.SaveAs ("d:/Test.doc")
End Sub

6. How to Save and Close a word document using VBA?

Here is the following VBA procedure to create a word document as a read only document.

'Save and Close Document
Sub Save_Close_Document()
  Documents.Close SaveChanges:=wdSaveChanges
  Application.Quit SaveChanges:=wdSaveChanges
End Sub

7. How to Close a word document without saving using VBA?

Here is the following VBA procedure to create a word document as a read only document.

'Close document without save
Sub DoNotSave_Close_Document()
  Documents.Close SaveChanges:=wdDoNotSaveChanges
  Application.Quit SaveChanges:=wdDoNotSaveChanges
End Sub

8. How to move cursor to the start of the document using VBA?

Here is the following VBA code. It takes cursor to the start of the document.
code:

Selection.HomeKey Unit:=wdStory

9. How to move cursor to the end of the document using VBA?

Here is the following VBA code. It takes cursor to the end of the document.
code:

	Selection.EndKey Unit:=wdStory

10. How to move cursor to the start of the line in Word document using VBA?

Here is the following VBA code. It takes cursor to the start of the line.
code:

	Selection.HomeKey Unit:= wdLine

11. How to move cursor to the end of the line in Word document using VBA?

Here is the following VBA code. It takes cursor to the end of the line.
code:

	Selection.EndKey Unit:= wdLine

12. How to select entire word document using VBA?

Here is the following VBA code. It selects entire word document.
code:

Selection.WholeStory

13. How to select the current line in a word document using VBA?

Here is the following VBA snippet. It selects entire word document.

'Select the current line in a word document
Sub Select_Line_Document()
    Selection.HomeKey Unit:=wdLine
    Selection.EndKey Unit:=wdLine, Extend:=wdExtend
End Sub

14. How to change the font size of third paragraph in a word document?

Here is the following VBA macro. It changes the font size of third paragraph.

'Change font size of 3rd paragraph
Sub Paragraph_Font_Size_Document()
     ActiveDocument.Paragraphs(3).Range.Font.Size = 10
End Sub

Save Up to 85% LIMITED TIME OFFER

MS Word VBA Interview Questions and Answers with Examples