Do you mean that the newly opened workbook doesn't get saved and closed? The
sheet selecting seems somewhat redundant.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dhatul" wrote in message
oups.com...
I had raised a problem earlier at the following link. However no one
has responded.



http://groups.google.com/group/micro...6115afd866b041

While trying to tinker with the macro to find a solution I am surprised
to find that even the following simple macro is not executing any line
after opening the other workbook -

Sub RunAll()
Workbooks.Open Filename:="C:\Data\GLIF\Test2148.xls"

Workbooks("Test2148.xls").Activate

' nothing below this line is being executed

Sheets("2148").Select
Sheets("Summary").Select
Sheets("RawData").Select
ActiveWorkbook.Save
ActiveWorkbook.Close

Sheets("Movement").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

Can someone suggest a solution?