Code for Registering Add-in
 

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
------------------------------------------------------------------------
zainul_ulum's Profile: http://www.excelforum.com/member.php...o&userid=24476
View this thread: http://www.excelforum.com/showthread...hreadid=386320

Code for Registering Add-in
 

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

Code for Registering Add-in
 

Dear keepITcool,

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

---
znl


--
zainul_ulum
------------------------------------------------------------------------
zainul_ulum's Profile: http://www.excelforum.com/member.php...o&userid=24476
View this thread: http://www.excelforum.com/showthread...hreadid=386320

Code for Registering Add-in
 

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