Code for Registering Add-in

[zainul_ulum]

Dear forum

I have excel addin (said first.xla).
some codes in first.xla refer to other procedure in second.xla

How to register second.xla and make this file listed in "References VBA-Project" with visual basic ?

thanks advance

znl

[keepITcool]

change the VBAProject Names for your addins to s't meaningfull
via properties window " e.g. "MyInterface" resp "MyFunctions"

Then activate First.xla (the caller) then via Tools/References
select the reference to MyFunctions and CHECK it.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


zainul_ulum wrote :

>
> Dear forum
>
> I have excel addin (said first.xla).
> some codes in first.xla refer to other procedure in second.xla
>
> How to register second.xla and make this file listed in "References
> VBA-Project" with visual basic ?
>
> thanks advance
>
> znl

[zainul_ulum]

Dear keepITcool,

Your steps still apply set references manually.
Is it possible to make these steps easier in vba codes ?

---
znl

[keepITcool]

yes

see
Activeworkbook.VBProject.References.AddFromFile


but since you're writing to the VB Project you're dependent
on the user's setting of Allow Accesss to Visual Basic Project
in macro security options.






--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


zainul_ulum wrote :

>
> Dear keepITcool,
>
> Your steps still apply set references manually.
> Is it possible to make these steps easier in vba codes ?
>
> ---
> znl