Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
How turn off macro security question for workbook with no marcos? | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions |