Closing another workbook stops the macro in the initial one

Hello everyone,

I am currently trying to delete an Excel file from the inside.
Knowing that it's impossible while it's open, I tried to do like so :

1:Open another workbook
2:Give it the first workbook's infos (name, path..) by writing it in the sheet
3:Run the second workbook macro

That macro does the following :

1:Get the first workbook's infos from the sheet
2:Close the first workbook
3:Kill it
4:Close the second workbook

The problem is, when closing the first workbook, it closes the first macro which aborts the second one. Basically, everything stops after closing the first workbook.

I tried executing the second macro with a workbook_open() event but even with a delay it doesn't get the first workbook's infos.

I am a bit desperate, your help would be much appreciated !

Thank you,

François

Sorry guys, I didn't received response notifications :/

I somehow managed to do it using a vbscript with arguments, which is pretty efficient.

Nevertheless, I keep those solution as I surely will need them soon. Thank you !

François