Hi!
I need to save a workbook in a different path with a different name, based on some of the users inputs.
To do so I used this code:
Dim Name As String
Name = Sheets("Form").Range("g7").Value & " - " & Sheets("Form").Range("c5").Value & "\" & Sheets("Form").Range("a1").Value & "_" & Sheets("Form").Range("g5").Value & "_" & Sheets("Form").Range("c7").Value & ".xlsx"
ActiveSheet.SaveAs Filename:="\\acswpj3\dfs_ceng\Refri\privado\Pilar Segurança\2017\Rotas de Segurança\" & Name
End Sub
But I keep getting the "Application - defined or object - defined error"
Bookmarks