Need Help saving workbook with VBA (specific filename)

[JumboCactuar]

Hi,
Sorry if this is not much to go on but im wanting to save workbook by vba to a set directory (directory in cell)

Example (Sheet1):
A1 = c:\temp\reports\

B1 = 24-03-2017

I would like it saved in the above directory with filename:
Report_24-03-2017.xlsm

Also is it possible, to clear 2 worksheets of the new file? To get its size low as possible

Is all this possible from a macro?

Thanks for any help

 

[JackDanIce]

Try:

Workbooks.SaveAs Range("A1").Value & "Report_" & Range("B1").Value) & ".xlsm"

 

[MrJoosten]

Sub Save()
Dim s1 As String
Dim s2 As String
s1 = Cells(1, 1).Text
s2 = Cells(1, 2).Text
ActiveWorkbook.SaveAs Filename:="" & s1 & "Report_" & s2, FileFormat:=53, CreateBackup:=False
Sheets("nameofyoursheet").Delete
Sheets("nameofyoursheet").Delete

End Sub

 

[JumboCactuar]

Thanks for the replies, both look good.

I forgot to mention that i dont want any sheets of the current workbook cleared, only the ones of the new workbook. Not sure if the above does this but ill try it out.

 

[JumboCactuar]

Sub Save()
Dim s1 As String
Dim s2 As String
s1 = Cells(1, 1).Text
s2 = Cells(1, 2).Text
ActiveWorkbook.SaveAs Filename:="" & s1 & "Report_" & s2, FileFormat:=53, CreateBackup:=False
Sheets("nameofyoursheet").Delete
Sheets("nameofyoursheet").Delete

End Sub

hi,this saves ok but after running the macro - the saved workbook is open
if possible i would like the original workbook to stay open as it was before running macro

 

[JumboCactuar]

bump

 

[JumboCactuar]

Still need help with this please

Basically just need to save into the directory but keep the existing workbook open.

All scripts ive tried "save as" then the new file is open