G gus Aug 27, 2003 #1 is it possible to add a reference to word form Tools>References by macro? I mean a macro to run and add this reference
is it possible to add a reference to word form Tools>References by macro? I mean a macro to run and add this reference
T Tom Ogilvy Aug 27, 2003 #2 http://support.microsoft.com/default.aspx?scid=kb;en-us;160647 XL97: How to Programmatically Create a Reference http://support.microsoft.com/default.aspx?scid=kb;en-us;213529 XL2000: How to Programmatically Create a Reference Can't do it before xl97 and method for xl2002 would be the same. Also, see Chip Pearson's site for additional information on programming the VBE http://www.cpearson.com/excel/vbe.htm note that you don't need a reference to the VBA extensibility library to create the reference if you use late binding.
http://support.microsoft.com/default.aspx?scid=kb;en-us;160647 XL97: How to Programmatically Create a Reference http://support.microsoft.com/default.aspx?scid=kb;en-us;213529 XL2000: How to Programmatically Create a Reference Can't do it before xl97 and method for xl2002 would be the same. Also, see Chip Pearson's site for additional information on programming the VBE http://www.cpearson.com/excel/vbe.htm note that you don't need a reference to the VBA extensibility library to create the reference if you use late binding.
