excel - How to save new workbook in a desired folder?

Question

I'm trying to save a new workbook (i.e. workbook2) to a desired folder based on the path in cell D7 of workbook1. Tried the following code but the file is not saved in the folder I want.

Dim path, Workbook_Name, workbook_main, workbook_path As Variant
path = Range("D7")
Workbook_Name = Range("B12") & Range("B13") & ".xlsm"
workbook_path = path & "" & Workbook_Name
ActiveWorkbook.SaveAs workbook_path, FileFormat:=xlOpenXMLWorkbookMacroEnabled

question from:https://stackoverflow.com/questions/65839026/how-to-save-new-workbook-in-a-desired-folder

Answer 1

Waitting for answers