How to delete the active workbook via VBA

First, where is your code? If you close the file that contains the code that is running, the code will stop running at the point where the file is closed.

Yeah I tried to do that but the problem is, the name of the file to delete is never the same.
I thought of something like this :

Macro in the file I want to delete:

1- keep the full name and the name of the worksheet in string variables
2- open the intermediary workbook
3- put the full name string value in A1 cell and name string value in A2 of the freshly opened worksheet
4- run the macro in the intermediary file

then the said macro :

1- get the name and full name of the deleteable file from A1 & A2
2- close the deleteable file
3- kill it
4- close the intermediary file without saving

I tried to do something like that but couldn't manage to get rid of that file. I know it works though because by puting the first file's name and path manually I had it deleted.

I know this isn't code, just directions, but can anybody tell me if the way I try to do it is able to do the trick, or not (and if so, why ? )

I am going to try some more, and provide my macros' code.

Here it is :

Macro in the target file :

Please Login or Register  to view this content.

Macro in the buffer file :

Please Login or Register  to view this content.

In the end, the target file still remains undeleted, and Buffer.xlsm doesn't even close...

I have genuinely no idea why it doesn't do the job...


EDIT : I found out that the buffer's macro stops after closing the first file... The following appears to work, though !

So I just have to find why it breaks here, and how to fix it !