Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word doc in listbox
I have created a UserForm with a ComboBox(ComboBox3) and a ListBox(ListBox5).
The ComboBox has several entries in it (ie. 1 2 3 4 5 ...). If I choose 2 I would like the ListBox to automatically be populated with a specified Word document. I'm calling this procedure after I have made my chioce in the ComboBox, this procedure displays the word document but not in the listbox. It stats a seperate window with the document displayed. I want to have the file show up in the listbox as read only. Sub ListBox5_update() Set oWord = CreateObject("Word.Application") oWord.Visible = True Set WORDObject = oWord.Documents.Open("C:\file.doc") End Sub Any help would greatly be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
Cell link in a form listbox - can it show a word? | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |