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?
Bookmarks