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