Open Workbook2 from Workbook1 and close workbook1

[Oseitutuakrasi]

I am trying to open a series of workbooks one at a time from command buttons. In each workbook I have a button on a form. For example, when I click the button on UserForm1 in WORKBOOK1, I open workbook2 and then close workbook1 in the process. Then in workbook2, I click a button and open workbook3, then close workbook2 etc. etc. Unfortunately, the previous workbooks don't close so I have all the workbooks open.
On the other hand, if I manage to close the previous workbook, then the UserForm in the current workbook is not displayed. For example if I open workbook2 from workbook1 and then manage to close workbook1, the userform in workbook2 is not shown, so I cannot click any button to open the next workbook. I have only one form in each workbook, and I use Workbook_Open() to show the form as the workbook is being open
(UserformX.Show). It appears that if I open Workbook2 from workbook1 and the close workbook1, workbook2's Open event is not executed. But if I DONT CLOSE workbook1, workbook2' Open event runs. I am using VBA for all this. If I am making sense, can someone help me please?
Good Day

 

[NdNoviceHlp]

Here's my guess. Your userform resides in wb1 and if it remains open you can't close wb1. You should be able to open and close whatever wb(s) from your userform, but not wb1. It would be best to show your code that your using. HTH. Dave

 

[Oseitutuakrasi]

Here's my guess. Your userform resides in wb1 and if it remains open you can't close wb1. You should be able to open and close whatever wb(s) from your userform, but not wb1. It would be best to show your code that your using. HTH. Dave

 

[Oseitutuakrasi]

Thanks Dave. With your suggestion, I will tackle from another angle, such as closing userforms in wb1 as I open wb2 so I can close wb1. Great suggestion.
I thin this will work. Many thanks
Samuel

 

[Oseitutuakrasi]

Hello Dave,
as you suggested, I have copied my code below. I have also tried to explain the code in the commented lines.
=====================================================================

Private Sub cmdNext_Click()

'COMMENT:  The next line of code is run from a button in Wb1 (cmdClick). It opens Wb2 (Exercise2.xlsm is a workbook)

Workbooks.Open ThisWorkbook.Path & "\Exercise2.xlsm"

' COMMENT: When Wb2 is loaded, I try to close the form that loaded it. Then I try to close Wb1 (that contained the form). No success.

Unload UserForm1
Workbooks("Exercise1.xlsm").Close SaveChanges:=False

'COMMENT: I have also copied the above two lines into the Wb2's Workbook_Open event hoping that when Wb2 is opened it will close Wb1. Yet no success

'Wb2 is loaded alright, but Wb1 is NOT closed; both are loaded with their userforms. 'It appears that when I open Wb2 from Wb1 with a code, it does not execute the Wb2's Workbook_Open event. (I tested this with a Msgbox). However, when I open Wb2 from the desktop, of course the Workbook_Open event runs.
End Sub

 

[NdNoviceHlp]

I messed around with this for a while. It's some type of automation conundrum. You can't close the wb before opening another wb, and when you open another wb, the wb open event fires and shows the userform which hangs the closing of the original wb. You may need to re-work your approach and have 1 master wb that has all the code to open/close other wbs and draw whatever info you want from them. Sorry, no easy solution. Dave

 

[Oseitutuakrasi]

I messed around with this for a while. It's some type of automation conundrum. You can't close the wb before opening another wb, and when you open another wb, the wb open event fires and shows the userform which hangs the closing of the original wb. You may need to re-work your approach and have 1 master wb that has all the code to open/close other wbs and draw whatever info you want from them. Sorry, no easy solution. Dave

Thanks Dave. It appears simple but indeed no easy solution. I thought my Office has been corrupted so I reinstalled it, hoping....
Thanks for confirming for me. I will try your suggestion. Thanks again
Samuel