Pulling Excel data into Word

[Chaucer]

I am trying to populate a dropdown box in word from an excel file that is located remotely on our intranet. I thought it would be a simple thing to do but I am having all kinds of problems with it (I'm using vbscripting). Anybody have an example they would be willing to share.

Thanks in advance.

*edit* Basically I'm wanting to run the script on Document_Open().

 

[Anne Troy]

Well... I hate to say it, but I've got code that does that, I believe. Only it's in a book that's not yet released:

http://www.amazon.com/exec/obidos/t...104-3417981-0136756?v=glance&s=books&n=507846

You could try emailing MrExcel directly, and asking him if he minds if we give you the code.

 

[Chaucer]

I got it figured out. I guess I could post my code.