Check the Word box in references via code?

[Trikageon]

Hey all! I'm writing a macro which will be shared by other users who most-likely won't have references to MS Word enabled (the box checked in Tools->References). Is there a code I can put in there that would activate this, if necessary? Thanks!

 

[Legacy 98055]

Use late binding in your code.

 

[Trikageon]

Please expound...

 

[Legacy 98055]

You will find as good or better info than I can give you here:

http://www.google.com/search?source...te+binding+word&aq=f&aqi=g1&aql=&oq=&gs_rfai=

 

[Trikageon]

Ok, I've looked to see what that is and have tried a few things on my own, but nothing I'm doing seems to work. I really don't have all day to sit and figure this out, so I was hoping someone who already knew and/or had some experience with this could help.

Basically, the end result of what I want to accomplish is to copy a range from excel to word and then copy it back to excel again (I'm doing this as an "easy" way to hard code some conditional formatting I have in excel).

 

[Legacy 98055]

You are welcome to post your code. Your answer is definitely to late bind your reference to word. You will not need to have an early bound reference from the VBA editor if you late bind to word from within your code. Post it if you have time...