Open Userform in different workbook

[Endorphin]

Hi All,

I have two workbooks, both completely userform driven, the user does not get to see the worksheets at any stage.

What I am trying to do is swap workbooks via the userforms so clicking a command button opens up the second workbook and Userform and saves the original one.

I have the code to automatically open the userform when the work book is loaded but it does not seem to work while swapping, however it does work when used individually.

Any help appreciated.

Neil

 

[RoryA]

What code are you using to automatically load the other form - Autpen or Workbook_Open?

 

[Endorphin]

Workbook_Open

 

[RoryA]

OK, so what code are you using to open the second workbook? (I assume you haven't set EnableEvents to False somewhere?)

 

[Endorphin]

Hi Rory,
No have not set any EnableEvents commands

Im using : Workbooks.Open "C:\Status Logs\Picc.xls" to open the second workbook

Neil

 

[RoryA]

That should work. Have you tested to see if the Open event in the second workbook is being called?

 

[Endorphin]

Hi Rory,

Solved, but not sure how.
I cut all the WorkBook_Open code and pasted it into a text document then tried it with application run after opening the book, then put the Open code back in and it worked, really have not idea why.

I spent 4 hours trying to get it to work yesterday, and changed no code...lol

Thanks for trying to help and sorry to have wasted your time.

Neil

 

[RoryA]

No worries - at least it's working!
If I were you though, I'd run code cleaner on the workbook just to clear out any p-code garbage.

 

[Endorphin]

Whats code cleaner and does it have to be installed on the machine?

 

[RoryA]

This, and yes.
Note: you can achieve the same thing by hand by exporting all the code, removing the modules and reimporting the code.