Does anyone know how to select a reference from the list of references with VBA code? Thanks in Advance, Mike
Hi Mike: The only thing that I could think of is an undocumented Office 95 "LOADONSTARTUP" registry key. I'm not sure if it still works, but you can try it. It's usually mentioned in VBA references for Access (go figure, huh?). If you use something like Installshield when you load your template you can set it to add a registry line that automatically forces Word to look for porcedures in other library databases using the LoadOnStartup Registry key. More on the subject can be found in: http://www.fmsinc.com/tpapers/vbaint/ and http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_addinhlp.asp Good luck- Al "Helper Monkey" wrote in message news:MPG.1cd6b2154ecd08659896b3@netnews.worldnet.att.net... > Does anyone know how to select a reference from the list of references > with VBA code? > > Thanks in Advance, > > Mike
Actually, now that I'm at home, the textbook "Access 2000 Developer's Handbook, Volume 1: Desktop Edition" by Getz/Litwin/Gilbert confirms that the LOAKONSTARTUP key method works well in Office 2000 applications (and probably on up). They have extended their coverage of this method (see page 1348). Good luck! Al "Al Borges MD" <alborg at erols dot com> wrote in message news:eZnueR3UFHA.580@TK2MSFTNGP15.phx.gbl... > Hi Mike: > > The only thing that I could think of is an undocumented Office 95 > "LOADONSTARTUP" registry key. I'm not sure if it still works, but you can > try it. It's usually mentioned in VBA references for Access (go figure, > huh?). If you use something like Installshield when you load your template > you can set it to add a registry line that automatically forces Word to > look for porcedures in other library databases using the LoadOnStartup > Registry key. More on the subject can be found in: > > http://www.fmsinc.com/tpapers/vbaint/ > > and > > http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_addinhlp.asp > > Good luck- > > Al > > "Helper Monkey" wrote in message > news:MPG.1cd6b2154ecd08659896b3@netnews.worldnet.att.net... >> Does anyone know how to select a reference from the list of references >> with VBA code? >> >> Thanks in Advance, >> >> Mike > >
You would use the VBA for Extensibility 5.3 library and work via the VBE and VBProjects objects. -- http://www.standards.com/; See Howard Kaikow's web site. "Helper Monkey" wrote in message news:MPG.1cd6b2154ecd08659896b3@netnews.worldnet.att.net... > Does anyone know how to select a reference from the list of references > with VBA code? > > Thanks in Advance, > > Mike
