Hi @Kunal_Jain
If you want an code means please check in below
Declare variables to hold the path of the read-only file and the new file name and path.
Dim readOnlyFilePath, newFilePath
Set the variables to the actual path of the read-only file and the new file name and path.
readOnlyFilePath = “C:\MyFiles\ReadOnly.xlsx”
newFilePath = “C:\MyFiles\Editable.xlsx”
Open the Excel application and the read-only file.
Set excelApp = CreateObject(“Excel.Application”)
Set workbook = excelApp.Workbooks.Open(readOnlyFilePath)
Save the file as a writable file using the SaveAs method.
workbook.SaveAs newFilePath
Close the Excel application and release the objects from memory.
workbook.Close
excelApp.Quit
Set excelApp = Nothing
Set workbook = Nothing