I am using Access VBA to Instantiate Excel and write data to Excel. Procedure writes data perfect. The one issue that I have is that I want the Access VBA to, if Excel file already exists, to over-write the file with no prompt. I have tried this syntax, but it still asks for confirmation before over-writing. What do I change to over-write the file?
Code:
Public Sub Test()
Dim wb As Object, saveloc As String
'Setting Save location
saveloc = "C:\Excel\Testing\Testworkbook.xlsx"
'Saving the workbook
wb.SaveAs filename:=saveloc
'Closing the workbook
wb.Close
End Sub