Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
TVK TVK is offline
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform listbox cannot get listbox.value to transfer back to main sub [email protected] Excel Programming 1 May 17th 06 09:44 PM
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) modjoe23 Excel Programming 3 August 18th 05 02:35 PM
Cell link in a form listbox - can it show a word? Dave Peterson[_3_] Excel Programming 0 January 27th 04 01:58 AM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM
Is refreshing listbox rowsource in listbox click event possible? Jeremy Gollehon[_2_] Excel Programming 4 September 25th 03 06:45 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"