Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Registering an even handler | Excel Programming | |||
Registering an OCX with VBA | Excel Programming | |||
ActiveX registering problem with VBA | Excel Programming | |||
ActiveX registering problem with VBA | Excel Programming | |||
error in registering msadox.dll | Excel Programming |