Problems in running a macro in another workbook

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?

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" <in_rkapoor@yahoo.com> wrote in message
news:1137667549.096131.101310@g14g2000cwa.googlegroups.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?
>

Bob,

To respond to your query only the worksheet '2148' opens and nothing
happens after that. That is to say that no line are executed
thereafter. The selects are not redundant as these were written
precisely to check whether the macro is being executed or not.
Incidentally, the above small macro was written for debug purpose only,
to home down to the problem area. The real macro that I want to be
executed is in the link provided in my original post.

More importantly the entire macro works/executes perfectly in the debug
mode when executed line-by-line (F8).

Perhaps there is not a sheet named "2148" in Workbook Test2148.xls so the
macro just stops.........

Vaya con Dios,
Chuck, CABGx3

"dhatul" wrote:

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