I am trying to have Excel open a save as and prefill the name based on a concat cell, but NOT prefill the location.
I am good with excel but the VBA is going over my head. This is what I have
Sub SaveFile()
Dim NameFile As Variant
With Worksheets("Settings")
NameFile = .Range("X2") & ".xlsm"
End With
ThisWorkbook.SaveAs FileName:=NameFile
End If
End Sub
I am good with excel but the VBA is going over my head. This is what I have
Sub SaveFile()
Dim NameFile As Variant
With Worksheets("Settings")
NameFile = .Range("X2") & ".xlsm"
End With
ThisWorkbook.SaveAs FileName:=NameFile
End If
End Sub