Sub SaveAs()
'
' SaveAs Macro
'
'
If IsEmpty(Range("F3")) Then
MsgBox ("Enter Form Title")
Cancel = True
Exit Sub
End If
ThisFile = Range("f3").Value
ActiveWorkbook.SaveAs Filename:="http://teamsna.us.com/vis/fist/NP/Price Prioritization Form/" & ThisFile & ".xlsm", FileFormat:=52
Application.Quit
End Sub
---
I'm getting a 1004 error "Document Not Saved" and it's highlighting the code in red
'
' SaveAs Macro
'
'
If IsEmpty(Range("F3")) Then
MsgBox ("Enter Form Title")
Cancel = True
Exit Sub
End If
ThisFile = Range("f3").Value
ActiveWorkbook.SaveAs Filename:="http://teamsna.us.com/vis/fist/NP/Price Prioritization Form/" & ThisFile & ".xlsm", FileFormat:=52
Application.Quit
End Sub
---
I'm getting a 1004 error "Document Not Saved" and it's highlighting the code in red