Macro to close two workbook

**JamesT1** · 04-23-2019, 11:18 AM

Good afternoon all

I have two workbooks,,,, 'Driver Database' (DD) and 'Driver Standard Routes' (DSR)..

In the userform on the DD i have a command button to close the userform and open the DSR Sheet... this works OK...

On the DSR I have command button to clost the DSR, this works OK,, but I also need it to close the DD sheet... I have been trying various version of the code, including switching the two lines around,, but cannot get it to close the DD sheet

Any help would be very much appreciated

Many thanks JT

Please Login or Register  to view this content.

**Greg M** · 04-23-2019, 11:44 AM

Hi there,

Knee-jerk (and untested!) suggestion, try:

Please Login or Register  to view this content.

You don't need to explicitly unload the UserForm - this will happen automatically when the workbook is closed.

Hope this helps,

Regards,

Greg M

**JamesT1** · 04-23-2019, 11:59 AM

Thanks Greg M

That closed the DD workbook but not the DSR,, and many thanks for the tip on the Userform

JT

**Greg M** · 04-23-2019, 03:03 PM

Hi again,

Ok, another (again untested!) suggestion:

Please Login or Register  to view this content.

And include the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

If this doesn't work I'm going to need to see a copy of your workbook so that I can understand exactly what should be happening.

As before, please let me know how you get on.

Regards,

Greg M

Macro to close two workbook

LinkBack

Thread Tools

Rate This Thread

Display

Macro to close two workbook

Re: Macro to close two workbook

Re: Macro to close two workbook

Re: Macro to close two workbook

Thread Information

Users Browsing this Thread

Similar Threads

Copy from first workbook, close open new workbook paste close

Macro VBA Excel : save and close a workbook from another workbook macro

[SOLVED] Macro to close all workbooks except active workbook and one other named workbook

[SOLVED] Issue with Open, copy, close Macro - when trying to close workbook Clipboard error

Macro to close workbook and replace with new workbook

How to open,save and close another workbook from the current workbook using macro?

Bookmarks

Bookmarks

Posting Permissions