| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Challenge (Linking word and Excel)
I think this question is going to need a VBA Wizard Is it possible to link for MS Excel to Word ? if so I am trying to open a MS Word doc whilst in a userform in Excel The document I want to open is held in a text box within the userform How could this be done ? Regards Marcus MArcus |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A Challenge (Linking word and Excel)
What if you add a RichTextBox to the form instead of a normal TextBox?
The thing below seems to work quite okay... Private Sub GetWordDoc() Dim wDoc As Object Dim wFileName As Variant wFileName = Application.GetOpenFilename("MS Word Documents (*.doc),*.doc", , "Pick a Word Doc") Set wDoc = GetObject(wFileName) RichTextBox1.OLEObjects.Add , , wFileName End Sub "Mr M Walker" schreef in bericht ... I think this question is going to need a VBA Wizard Is it possible to link for MS Excel to Word ? if so I am trying to open a MS Word doc whilst in a userform in Excel The document I want to open is held in a text box within the userform How could this be done ? Regards Marcus MArcus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Word and Excel | Excel Discussion (Misc queries) | |||
| Linking Word and Excel | Links and Linking in Excel | |||
| vba linking Excel and Word | Excel Worksheet Functions | |||
| linking excel to word | New Users to Excel | |||
| Linking Excel and Word | New Users to Excel | |||
![Mr M Walker[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
