add ocx reference at runtime and programatically

[Guest]

I'm want to programatically add a reference to an OCX file so my users do not have to manually go to 'tools', 'references', 'browse'. Is there a way to register a valid OCX file in the system32 directory in a fasion simular to registerxll?

 

[Rob van Gelder]

Sub test()
ThisWorkbook.VBProject.References.AddFromFile
"C:\WINDOWS\SYSTEM32\COMCTL32.OCX"
End Sub

--
Rob van Gelder - http://www.vangelder.co.nz/excel

I'm want to programatically add a reference to an OCX file so my users do

not have to manually go to 'tools', 'references', 'browse'. Is there a way
to register a valid OCX file in the system32 directory in a fasion simular
to registerxll?