Select from a variety of word templates which filepath to open

[jollycobra]

I would like to use a file path with a variable in it.

Dim rs as recordSet
Dim Path as String
Dim ReportName As String

Set ReportName = me.txtreportName 'a textbox on a form to which the code is attached.
 
Path = ""C:\Users\MyUserName\Documents\Custom Office Templates\"ReportName".docx""

Please help. I've been at this for some time and nothing is working. Thanks

[twinnyfo]

jollycobra,

Welcome to Bytes!

This should be the proper syntax:

Dim rs as recordSet
Dim Path as String
Dim ReportName As String

ReportName = me.txtreportName 'a textbox on a form to which the code is attached.

Path = "C:\Users\MyUserName\Documents\Custom Office Templates\" & ReportName & ".docx"

Then, there are a variety of ways to open that file.