Creating a file in VBA Macro and saving it in a specific location

[anshikam]

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

 

[mohadin]

You are welcome