Delete current workbook + parent folder

[Kelvin Stott]

Hi, I have been struggling to write some VBA code (tried many variations) that will close the workbook in which the VBA code runs, then delete the workbook itself as well as the entire folder that contains it. The problem is the code can’t delete the workbook and folder unless and until the workbook is closed, but the code itself stops running when the workbook is closed so it also won’t delete the workbook and folder. How to allow the VBA code to keep running and delete the workbook and folder after the workbook containing the VBA code is closed???

 

[JoeMo]

Put the code in your PERSONAL.XLSB workbook and run it from a button on the Quick Access Toolbar.

 

[Kelvin Stott]

Thanks, but I need to keep the code integrated within the workbook itself, so that the workbook effectively deletes itself and the folder that contains it. So I was wondering if the VBA code can be made to continue running after the workbook that contains it is closed?

 

[JoeMo]

Thanks, but I need to keep the code integrated within the workbook itself, so that the workbook effectively deletes itself and the folder that contains it. So I was wondering if the VBA code can be made to continue running after the workbook that contains it is closed?

Don't know. Try it on a copy of the workbook.