loading object libraries / references dynamically

Question

Hi all, 
 we're using some routines for excel output on different machines (using Excel Object Library.) 
 There we find different versions of excel and so different versions of object libraries: 
 
 How can we read the loaded references and load appropriate versions dynamically? (with GUID or so) 
 Any help appreciated, 
 cheers Ingo

Robert Hook · Answer

Hi Ingo , 
 I added two common Microsoft VBA code snippets on our VBEIDE page that we occasionally have to recommend to users in need of troubleshooting their Microsoft VBA projects. 
 Feel free to try the VBEProjectReferences code snip to see if it helps provide the information needed. 
 If or when you encounter any issues, please see our MVBATroubleshooting page for some common troubleshooting steps that may be required. 
 Please note this is a MicroStation (not Microsoft) programming forum available to help users productively Search and Ask programming questions. 
 Since your question is purely a Microsoft issue (not MicroStation specific) you may find more helpful Microsoft responses on Microsoft Forums; however this forum certainly helps users that have a desire to learn and create their own Microsoft and MicroStation custom code solutions in the process. 
 HTH, Bob

loading object libraries / references dynamically

Top Replies