please help, trying to setup to save each individual new opened file as days or nights???? See below
thanks

A3 date(today)
A4 trying to put a dropdown option for days or nights



Private Sub CommandButton1_Click()
Dim Path As String
Dim Filename1 As String
Dim Filename2 As String
Path = "P:\595Geismar\EASTSIDE E-LOG TEST"
Filename1 = Range("A3")
Filename2 = Range("A4")
ActiveWorkbook.Saveas (Path & Filename1 & "-" & Filename2 & ".xls")
'"FileFormat"":=" = xlNormal
End Sub