Hand control to another workbook to delete current workbook

[BusterT]

I'm trying to delete a workbook that's currently open, but it needs to be done in following manner;

1. Open workbook1 & run some macros.
2. Workbook1 opens workbook2.
3. Workbook2 runs some macros.
3. Workbook2 deletes workbook1.


I've tried following but it doesn't work & it doesn't generate any errors at all. It just stops when workbook1 is closed.

Workbook 1

Please Login or Register  to view this content.

Workbook 2

Please Login or Register  to view this content.

I've tried few other things, even through ThisWorkbook Activate, but as soon as first workbook is closed it's the same issue everything stops.


So is there a way to hand control over to another workbook & do this? It seems like a file handle control issue but not sure how would do this.

[BadlySpelledBuoy]

Difficult to be sure without sight of the files involved, but try adding the below line just before your wb.close line.

Please Login or Register  to view this content.

BSB

[BusterT]

I've just tried that, same issue still.
The files in question are very bare bones as I've stripped them back to try & get this to work.

I guess a question would be, should this work?

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[BusterT]

I've uploaded 2 files, both contain macros. They both need to be in the same folder.

File2Delete contains a button & starts it, passes workbook object to ParentMain.
ParentMain contains macro that is supposed to delete the first one, which I've replaced with MsgBox so can see the issue.

Soon as File2Delete is closed, nothing else works & any strings created before it's closed that get stored in ParentMain is lost.