How to delete an Excel workbook using MsAccess VBA

[baba]

If a File exists in CurrentProject.Path & "\Book1.xlsx" , I want to delete it
and create a new file . How can I do it using MsAccess vba . Please help !

Also how to create a new Workbook Book1.xlsx with only one WorkSheet called Sheet1

[June7]

Use Kill. Example:

Kill CurrentProject.Path & "\Book1.xlsx"

Bing: Access VBA create Excel file
http://www.tech-archive.net/Archive/.../msg00164.html

[ItsMe]

...
Also how to create a new Workbook Book1.xlsx with only one WorkSheet called Sheet1

Here is an example. You will need to add a save command with the path.
https://www.accessforums.net/access/...tml#post280600

[baba]

Thanks for the response. this helps