Export data in Work to different folders

[JPR]

Hello,

I have a form with a cmd button that exports data to MS Word template.

Presently the word file is saved via code too just one folder (C:\MyTemplate).

I would now like to change my code to save the word file into different folders depending on the selection in a textbox (txtfolder).

To export data into MS Word, I have a table (TablePath) with two fields which indicate the template used to copy the data (MyTemplate) and the path where the template is saved as a doc file (C:\MyTemplates\).

I was wandering how to specify the exact folder depending on the selection in txtfolder in the code below:

strSavePath = DLookup("[TemplateLocation]", "TablePath", "[TemplateID]='WordSavePathMyTemplate'")

Thank you

 

[Gasman]

You just concatenate strSavePath and Me.txtfolder into the path for the file?
If that is the total path then likely strPath & Me.txtFolder & "\" & strFile, providing strpath ends with a \. If not insert that between the two variables.

 

[JPR]

Works just great!
Thank you