How to delete the active workbook via VBA

[AstroZelda]

Hello,

I would like to know if it's possible for me to delete a .xlsm file simply by clicking a button which is in this very workbook.

I read something like this

Please Login or Register  to view this content.

But all it does is closing the workbook, which I can re-open afterwards, and leaving me in an empty, workbook-free Excel window.

Do you know why it does that, and how I could completely delete that workbook ?

Arigato gozaimasu !

François

[6StringJazzer]

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.

[AstroZelda]

Hello Jeff,

My code is indeed in the workbook, but all I wanted to do was to delete the file without leaving any leftover after the operation,
so I tried to put it all in one place.

If I really can't do so, I guess I can have another file hidden in my directory... But once again I don't know how to make it.

[JOHN H. DAVIS]

With the code in a separate file maybe?

Please Login or Register  to view this content.

[AstroZelda]

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.

[AstroZelda]

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 !

[AstroZelda]

Calling a VBScript from the workbook works perfectly, at last !