Opening a specific Word document from a text box

Question

Opening a specific Word document from a text box

InkyRich (TechnicalUser)

(OP)

6 Dec 20 23:41

Hi all,
I am trying to open an existing specific Word document from a double click in a text box on a form. This document (which already exists) is selected from the entry in the text box on the double click.
I have tried various methods to no avail. Can anyone suggest how this might be done please?

Hampshire UK.

There is nothing so sad as an old guy trying to code.

macropod (TechnicalUser) · Answer 1 · 2020-12-07 04:39:32

It would be helpful if you posted your code; otherwise all anyone can do is play a guessing game - not.

Cheers
Paul Edstein
[MS MVP - Word]

Andrzejek (Programmer) · Answer 2 · 2020-12-07 17:43:55

You can use this OpenDocument logic to open any document in its default app: wiggle

CODE

Option Explicit

Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Call OpenDocument(TextBox1.Text)
End Sub

Private Sub UserForm_Activate()
TextBox1.Text = "C:\SomeFolder\SomeFile.jpg"
End Sub

Public Sub OpenDocument(strDocPath As String)
Dim G As Long
G = Shell("RUNDLL32.EXE URL.DLL,FileProtocolHandler " & strDocPath, vbNormalFocus)
End Sub

---- Andy

There is a great need for a sarcasm font.

InkyRich (TechnicalUser) · Answer 3 · 2020-12-07 23:37:08

Thanks a lot Andy. I will give it a try.

Hampshire UK.

There is nothing so sad as an old guy trying to code.

Come Join Us!

Posting Guidelines

Opening a specific Word document from a text box