Open Word doc through app.path?

[jandrade15]

hello all-

I have the following code to open a word template in the app.path directory....

Dim appWord As Object
Dim strDoc As String
    strDoc = " & app.path & Labels1.dot"
    Set appWord = CreateObject("Word.Application")
    appWord.Documents.Open strDoc
    appWord.Visible = True

I get an error message that it cant find the document????

did I code this correctly? Thanks for all your help in advanced!!!

[Br1an_g]

Dim appWord As Object
Dim strDoc As String
    strDoc = " & app.path & Labels1.dot"
    Set appWord = CreateObject("Word.Application")
    appWord.Documents.Open strDoc
    appWord.Visible = True

your strDoc should be:

strDoc = app.path & "Labels1.dot"

also, you arent showing what is happening with app.path. so it could be this as well

HTH

[jandrade15]

Thanks so much worked out great!

[RobDog888]

Just wanted to point out that if your dot is in the root directory then you will end up with
double backslashes - C:\\Labels.dot.

If Len(App.Path) = 3 Then
    'In root dir
    strDoc = App.Path & "Labels1.dot"
Else
    'Not in root
    strDoc = App.Path & "\Labels.dot")
End If

[jandrade15]

AS ALWAYS YOU DA MAN ROB!!!!!! THANKS FOR ALL YOUR HELP!