how to save master workbook with different name

[margil patel]

i want one master workbook save as different names with all sheets & formulas.

 

[Khalid NGO]

Margil can you specify more about your need?

SAVE AS (short key F12) command is not fulfilling your requirement?

Regards,

 

[margil patel]

Thanks, But have lots of workbook name so i want use vba code for save workbook.

 

[Smallman]

Margil

Please post a sample of your workbook with more detail around what you are looking to change or save. This will supply some context to assist you.

Take care

Smallman

 

[margil patel]

I have this workbook and i want to copy this workbook and save with different name. using VBA Code

 

[Nebu]

ChDir "C:\Your File path here"
ActiveWorkbook.SaveAs Filename:="C:\Your file path here\your name.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

use this code, this is just a simple macro recording for save as...