VBA & Macro Problems

Fix a Missing Word Add-In Ribbon When Launching Word from Excel VBA

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 869 views

Question details

The user needs a Word DOTM add-in's custom Ribbon to appear when Word is launched from Excel or Access VBA.

Fix a Missing Word Add-In Ribbon When Launching Word from Excel VBA
Product
Microsoft Word and Excel VBA
Device & OS
not provided
Scenario
An automation macro starts Word and relies on a DOTM add-in in Word's Startup folder.
Observed behavior
The add-in may load, but its custom Ribbon does not appear when Word starts through VBA.
Before you start

Confirm that the DOTM file is in Word's configured Startup folder and that its custom Ribbon appears when you start Word normally. Close Word before testing a fresh automated launch so you can distinguish a new instance from an existing one.

Solution 1Recommended

Launch Word visibly and create an active document

Use this approach to test whether an active Word window and document allow the add-in Ribbon to appear.

The following Excel VBA example uses late binding, so it does not require a Word object library reference. It reuses an existing Word instance when available or creates a new one.

Word startup timing can affect add-in behavior in some Office versions, so this is a troubleshooting test rather than a guaranteed fix.

1
Open the VBA editor

In Excel, press Alt+F11, then choose Insert > Module.

2
Add the launch macro

Paste this code into the module: Sub OpenWordForRibbonTest() Dim wordApp As Object Dim wordDoc As Object On Error Resume Next Set wordApp = GetObject(, "Word.Application") Err.Clear On Error GoTo HandleError If wordApp Is Nothing Then Set wordApp = CreateObject("Word.Application") End If wordApp.Visible = True wordApp.Activate Set wordDoc = wordApp.Documents.Add wordDoc.Activate Exit Sub HandleError: MsgBox "Could not open Word: " & Err.Description, vbExclamation End Sub

3
Run and inspect Word

Place the cursor in the macro and press F5. In the Word window, check whether the add-in's custom Ribbon tab appears with the new document active.

Existing Word instances: The macro does not close Word. If it reuses an existing instance, restart Word and run the macro again to test a fresh startup.
Free Microsoft Office alternative

Work with Word documents in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office documents as you move between suites. It does not repair Microsoft Word's VBA add-in or Ribbon startup behavior.

Open and edit Microsoft Word DOC and DOCX files.Use a familiar Ribbon-style interface for document tasks.Work with documents in a lightweight, free Office alternative.Move common Office files between WPS Office and Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Ribbon appear when I open Word normally but not from Excel VBA?

The automated launch may use a different Word instance or leave Word without an active document. Test a visible Word window with a new active document, then compare the loaded templates under File > Options > Add-ins > Templates > Go.

Do I need a Word object library reference for Excel VBA?

You need the reference if your code uses early-bound types such as Word.Application. In the VBA editor, open Tools > References and enable the Microsoft Word object library. The late-bound example using Object and CreateObject does not require it.

Where can I find Word's Startup folder?

In Word, go to File > Options > Advanced > File Locations and check the Startup location. Confirm that the intended DOTM add-in is stored there.

Will WPS Office fix my Word VBA add-in Ribbon?

No. WPS Office is an alternative for working with Office documents, not a repair for Word's add-in startup behavior. Test any VBA macros and custom Ribbon features separately before migrating.