trying to save and close file, please help getting error 1004 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("A4")
Filename2 = ("B4")
ActiveWorkbook.Saveas (Path) & (Filename1) & (Filename2)
ActiveWorkbook.Close
End Sub