shell路径变量 vba,如何在路径内使用变量编写VBA

This is my second post on this site and an I am relatively new to VBA.

My today question is,

How can I add a cell value to the Path String to designate the folder where I would like the workbook to be saved.

Dim Path As String

Dim FileName1 As String

Dim FileName2 As String

Path = "D:\folder1\folder2\Projects\The FILES\theFILES\"FileName1"\

FileName1 = Range("B6")

FileName2 = Range("A1")

ActiveWorkbook.SaveAs Filename:=Path & FileName2 & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

Thanks in advance!

解决方案

Answer to stated question

Path = "D:\folder1\folder2\Projects\The FILES\theFILES\" & FileName1 & "\"

Also see additional feedback and corrected code for other feedback.

Long E