Opening and closing one workbook after another

**Nancy123** · 10-20-2010, 05:17 AM

Hi guys

Please find attached the workbooks. It should work each time you press Enter and Logoff button. When you press Enter button then startup form of another workbook should get opened and when we press close then second workbook should be closed and the startup form of first workbook should get displayed. The whole procedure in the attached workbooks works fine once but not if you do it again and again.

Thanks

**Nancy123** · 10-20-2010, 10:52 AM

Does anyone have the answer of my question?

Please help me solve it.

Thanks

**romperstomper** · 10-20-2010, 12:11 PM

Change the form in SAM2 to:

Please Login or Register  to view this content.

and the form in SAM1 to:

Please Login or Register  to view this content.

**Nancy123** · 10-21-2010, 04:12 AM

Hi Romper

Its not working properly. When I click on Logoff button of sam2 workbook then startup form of sam1 workbook should get opened.But it is not working as desired. Can you please check it again. First open sam1 workbook and press Enter button then in the new userform press logoff , Now the sam1 workbook should be opened but its not.

Thanks

**romperstomper** · 10-21-2010, 04:55 AM

Sorry - I should have tested that before posting. The closing of the second workbook by the second form is the issue.
Can you explain the process a bit more and tell us whether the second workbook is ever opened by itself, rather than from the first workbook?

**romperstomper** · 10-21-2010, 05:04 AM

Never mind, this should work.

**Nancy123** · 10-21-2010, 05:31 AM

It seems working fine. Is it also possible not to close sam1 workbook when sam2 workbook is opened that means displaying sam2 workbook userform upon sam1 workbook userform.

Thanks

**romperstomper** · 10-21-2010, 05:32 AM

Remove the Me.Hide and Me.Show lines from the first form.

**Nancy123** · 10-21-2010, 08:37 AM

Brilliant Romper. Thanks a lot for your help...

Opening and closing one workbook after another

LinkBack

Thread Tools

Rate This Thread

Display

Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Re: Opening and closing one workbook after another

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions