Open word doc from user form button

[ipbr21054]

Hi all,
I have a user form which has various text boxes containing info.
One text box relates to a word doc receipt as just a basic number system.
Is there a code we can use to apply to a button on the user form that would then look at a specific text box and open its relevant word doc receipt.

The text box which contains the receipt number on the user form is txtInvoiceNumber

The path to the word doc is C drive,REMOTES ETC,DR COPY INVOICES,Invoice 107.doc

Obviously this receipt is 107 but as time goes on more will be added 108,109,110 etc etc

Any advice would be great thanks.

I havent applied a button yet as awaiting code info.

 

[ipbr21054]

I have applied the following code to a now inserted command button on the user form.

Private Sub CommandButton1_Click()Set wordApp = CreateObject("word.application")
wordApp.Documents.Open ThisWorkbook.Path & "/" & TextBox14.Value & ".doc"
wordApp.Visable = True
End Sub

Please can you advise how i correctly add the path, C drive,REMOTES ETC,DR COPY INVOICES,Invoice 107.doc

 

[ipbr21054]

Just an update and now stuck.
The following it what ive done so far but after pressing the command button there is a long pause before i see a message.

Microsoft excel is waiting for another application to complete an OLE action

Code in use at present which needs a little more for it to work.

Private Sub CommandButton1_Click()Set wordApp = CreateObject("word.application")
wordApp.Documents.Open "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES" & "/" & txtInvoiceNumber.Value & ".doc"


End Sub