Combobox to open word documents from excel

gherzberg,

Here's the generic code to open a Word doc:

Shell "winword.exe ""C:\Folder\Subfolder\Filename.doc""", vbNormalFocus

So to adjust, you can use variables:

Dim strFolderPath As String

'Change to the correct folder path, don't forget the ending \
strFolderPath = "C:\Folder\Subfolder\"

Shell "winword.exe """ & strFolderPath & ComboBox1.Text & "wr.doc""", vbNormalFocus
Shell "winword.exe """ & strFolderPath & ComboBox1.Text & "fdl.doc""", vbNormalFocus