Hello,
Trying to create a file and save it in a specific location with the below code.
Error code I get is :
Run Time Error '424'
Object Required
Report = "RMC_Indemnity_Report" & a & " " & b & c & d & ".xls"
Dim Path As String
Path = "F:\Corporate\Anshika\Due Dates\sent\"
Workbooks.Add
ActiveWorkbooks.SaveAs Path & "\" & Report
Trying to create a file and save it in a specific location with the below code.
Error code I get is :
Run Time Error '424'
Object Required
Report = "RMC_Indemnity_Report" & a & " " & b & c & d & ".xls"
Dim Path As String
Path = "F:\Corporate\Anshika\Due Dates\sent\"
Workbooks.Add
ActiveWorkbooks.SaveAs Path & "\" & Report