Automate Data from Excel into Word DropDown...?

[Sgraves]

I am trying to create a dropdown list/menu in word and have it populate data
from excel without opening excel.

I created the dropdown list in word and I have an xls spreadsheet to pull
data from but I don't want to meilmerge; with a meilgerge I have to open
excel and I don't want that.

Do you have a clue how this can be done?

Thank you all.

 

[Jean-Guy Marcil]

Sgraves was telling us:
Sgraves nous racontait que :

I am trying to create a dropdown list/menu in word and have it
populate data from excel without opening excel.

I created the dropdown list in word and I have an xls spreadsheet to
pull data from but I don't want to meilmerge; with a meilgerge I have
to open excel and I don't want that.

Do you have a clue how this can be done?

You will have to open Excel to get info out of an Excel worksheet...
Depending on the Office version, you can open Excel invisibly, but you still
need to open it.
Why don't you want to open Excel?
Why do you mention mailmerge if you do not want to do a mailmerge?

Meanwhile, you may want to look at this to see how to manipulate Excel from
word:
http://word.mvps.org/faqs/interdev/controlxlfromword.htm

 

[Sgraves]

Thanks for responding so quickly.

The reason I don't want to open excel is because the users that will be
using this document will be confuse when the select from the dropdown.
However, making it invisible is not a problem.

The reason I mentioned mailmerge is because when asking this question before
someone told me I can do I mail mailmerge but that is not want I want, so I
want that option excluded.

When the user selects from the dropdown list on the left column, I want the
excel data to show up on the right column in word.

 

[Jean-Guy Marcil]

Sgraves was telling us:
Sgraves nous racontait que :

Thanks for responding so quickly.

The reason I don't want to open excel is because the users that will
be using this document will be confuse when the select from the
dropdown. However, making it invisible is not a problem.

The reason I mentioned mailmerge is because when asking this question
before someone told me I can do I mail mailmerge but that is not want
I want, so I want that option excluded.

When the user selects from the dropdown list on the left column, I
want the excel data to show up on the right column in word.

So look at the link I provided.

Post back with specific questions if you have problems, it would be better
then to start a new thread to get the attention of more posters...