VBA to open new workbook and run macro from new workbook, which closes old workbook

**Rerock** · 11-25-2014, 06:29 PM

Hi,
I'm running in to a problem I can't seem to figure out. I have two spreadsheets located in a folder, "BOOK1" and "BOOK2".

The intended process is to run MACRO1 on BOOK1. MACRO1 will open BOOK2, then call MACRO2 on BOOK2. MACRO2 will close BOOK1 without saving, then delete BOOK1 from folder

Using the code below, everything runs fine until line 2 on MACRO2; at that point the macro just stops for some reason and I don't know why.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can anyone please let me know how MACRO2 needs to change so it gets through line 5? Thanks!

**karedog** · 11-26-2014, 07:31 AM

Hi,

Even the line 2 on MACRO2 is fixed (so BOOK1 is closed), the rest of MACRO2 will not be executed, because as soon as the BOOK1 is closed (by line 2 statement), so the rest of code will terminated.

If you curious howto fix this line 2 :

Please Login or Register  to view this content.

So the trick is using timer function (Application.OnTime) to launch sub MACRO2 later, but before that happen, close BOOK1 by itself first. Please look at my attached file (zip file, contains 2 file : Book1.xls and Book2.xls)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards

**Rerock** · 11-26-2014, 10:13 AM

Simple. Concise. Functional. Beautiful work!

Thank you SO much for your help!

**karedog** · 11-26-2014, 10:45 AM

You are welcome, and many thanks for the reputation points.

Regards

VBA to open new workbook and run macro from new workbook, which closes old workbook

LinkBack

Thread Tools

Rate This Thread

Display

VBA to open new workbook and run macro from new workbook, which closes old workbook

Re: VBA to open new workbook and run macro from new workbook, which closes old workbook

Re: VBA to open new workbook and run macro from new workbook, which closes old workbook

Re: VBA to open new workbook and run macro from new workbook, which closes old workbook

Thread Information

Users Browsing this Thread

Similar Threads

The workbook closes, but the excel application remains open

Macro to open a closed workbook and select copy cells into an open workbook

Save an open workbook, then open template workbook and close the saved workbook

Auto-open macro closes workbook - how do I access its contents?

[SOLVED] VBAProject remains open after Workbook closes

Bookmarks

Bookmarks

Posting Permissions