Adding reference

[AlexanderBB]

I want to open a new workbook, paste in some code and run it. But it requires a reference that isn't present
So I run

Sub MySub()
    Application.VBE.ActiveVBProject.References.AddFromFile "C:\WINDOWS\$hf_mig$\KB2698365\SP3QFE\msado28.tlb"
End Sub

However this tells me "User defined type not defined' and highlights an entry in the declarations section.
I then have to rem this out, run the code and then undo the Rem
Is there any way Excel can have this reference all the time, so it doesn't need to be added.

 

[6StringJazzer]

Do you have an entry like this in your list of references? If not you can use Browse and go the location specified in the path in your line of code above.

 

[AlexanderBB]

I have tried adding the reference like that but it doesn't stick
Each time Excel opens I need to add it again.

Any solution to that?