Open/RunMacro/Save&Close Macro

I am using the following code to open a group of workbooks and run a macro inside and then save and close the workbook:

Please Login or Register  to view this content.

I added the below to the end of each individual macro within each workbook and now UpdateAll() won't go through each workbook in the folder and run the workbooks, it stops after opening one:

Please Login or Register  to view this content.

Hi,

The line in red below is probably the problem. The macro closes the file that is running the code. This terminates the Macro 'daisy chain' and causes all Macro activity to stop.

The solution is to have the father routine close the son file, like you do in the top macro.

Please Login or Register  to view this content.

Lewis

Thanks Lewis, I commented that out and it turns over to open the file well.
If I comment out:

Please Login or Register  to view this content.

That will close the current book and still go onto the next one in the folder, correct?

If I comment out 'Workbooks.Open Current' that will close the current book and still go onto the next one in the folder, correct?

Unfortunately, No. Workbooks.Open does not close files. All the previous workbooks you had open will still be open. The code has to be structured in such a way that closing a file does not break the daisy chain.

See the following thread which discusses your problem: http://www.excelforum.com/excel-prog...le-macros.html

There are download file associated with post #16 that you might want to try. Norie has a solution (have all the macros in one master workbook) that works in post #17, but Norie's solution is not always possible.

I hope this helps. It is a complicated situation. Please ask if you are still having questions and/or problems.

Lewis

Thanks Lewis!