Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Automate Data from Excel into Word DropDown...?
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. |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Automate Data from Excel into Word DropDown...?
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/c...xlfromword.htm -- ______________________________ Jean-Guy Marcil Montreal, Canada |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Automate Data from Excel into Word DropDown...?
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" wrote: 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/c...xlfromword.htm -- ______________________________ Jean-Guy Marcil Montreal, Canada |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Automate Data from Excel into Word DropDown...?
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... -- ______________________________ Jean-Guy Marcil Montreal, Canada |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate: Excel cell to Word? | Microsoft Word Help | |||
How can I automate a mail merge from Excel data & have it updateevery time? | Mailmerge | |||
Trying to automate data entry in word | Microsoft Word Help | |||
How to enter dropdown data into combobox in Word 2000? | New Users | |||
Automate data entry in Word document | Microsoft Word Help |