CODEWITHSUNDEEP
vbams-word
kown owl
kown owl

Reputation: 43

word add in cached and not able to remove it

there was originally an add-in installed for word, under the path

D:\User\UserName\AppData\Microsoft\Word\Startup\addin.dot

it is working fine, and it add to Word menu with a name addin_2017. Since it is already 2021, we figured its better to update the menu name, so we changed the name to addin_v2 instead. However, when we place the updated addin.dot into the folder, both name showed up in the Word add-in menu. addin_2017, and addin_v2. I am wondering if there are anything cached somewhere.

I have also tried to use VBA code to remove all the add-in, but when I copy the file back to the STARTUP folder, there are two items in the menu still.

enter image description here

Upvotes: 0

Views: 122

Answers (1)

Timothy Rylatt
Timothy Rylatt

Reputation: 7860

Looking back at some (very old) Wd2003 projects the method that I used was to have two separate routines for deleting and creating menus. These were called when the add-in was loaded and unloaded, e.g.

Public Sub AutoExec()

  DeleteMenu
  CreateMenu

End Sub

Public Sub AutoExit()

  DeleteMenu

End Sub

Public Sub DeleteMenu()
   Dim cbc As Office.CommandBarControl

   For Each cbc In Application.CommandBars("Menu Bar")
      If cbc.Caption = "AddinV2" Or cbc.Caption = "Addin2017" Then cbc.Delete
   Next cbc
End Sub

It is obvious from your investigations that the rogue menu exists in the addin. One option to remove it is to:

  1. Create a new template
  2. Export all the code modules from the existing addin
  3. Import the modules into the new template.

This should be seen as only a (very) temporary measure until you have created a new add-in with a custom ribbon tab.

Upvotes: 1

Related Questions