Do While Loop for Macros to run through various workbooks

**kchm_2000** · 10-18-2011, 11:50 PM

Hi,

I have 3 macros currently and wish to run them through a set list of workbooks found in file Auto Comment Control.xls, the Auto Comment (test) files represent the workbooks that I want the macros to run through. Thanks in advance for anyones' help

here is a list of the three macros

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**p24leclerc** · 10-20-2011, 04:11 PM

First of all, you must have your 3 macros in the Auto Comment Control.xls workbook. In your module4 (I think), you copy this macro which will open every files in the CONTROL workbook and run your 3 macros on them:

Please Login or Register  to view this content.

When the macro closes a workbook, it asks you to save changes or not. if you always want to save it, you can do it automatically with this small change in the command:

Please Login or Register  to view this content.

Good luck

**kchm_2000** · 10-21-2011, 12:12 PM

thanks i understand now

Do While Loop for Macros to run through various workbooks

LinkBack

Thread Tools

Rate This Thread

Display

Do While Loop for Macros to run through various workbooks

Re: Do While Loop for Macros to run through various workbooks

Re: Do While Loop for Macros to run through various workbooks

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions