word reference

G

gus

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top