I have 2 excel files(projects). How do I allow them to see each others modules and class modules??? I think I can make it happen using Tools -> References but I want to make the link in VBA.
Another requirement is that the referencing needs to be file location agnostic. So I will have to use a programmatic way to link the projects (So I can check an ini file that knows the location of the file to be referenced). ?
TIA
This message was edited by LoopCost on 2002-10-17 10:49
This message was edited by LoopCost on 2002-10-19 03:31
Another requirement is that the referencing needs to be file location agnostic. So I will have to use a programmatic way to link the projects (So I can check an ini file that knows the location of the file to be referenced). ?
TIA
This message was edited by LoopCost on 2002-10-17 10:49
This message was edited by LoopCost on 2002-10-19 03:31