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
Thanks

 

[vbaInet]

http://lmgtfy.com/?q=delete+file+++ms+access+++vba

The same principle can be followed for your workbook question. Give it a try and if you have any specific questions, please ask

 

[baba]

Thanks vbaInet. Your solution is something that I never tought of .I think u completely understood the purpose of the forum . thanks again

 

[vbaInet]

No problem! I'm glad you took it in good spirit

But please feel free to ask any questions if you need some more guidance or are struggling with getting the code to work.