Runing a macro in a workbook from another macro in other workbook

D

dhatul

I am trying to execute the following given macro from the current
workbook. The macro opens the workbook "2148.xls" and waits there. It
does not proceed to run the macro "NextDay" as given in line number 3.
However, if I execute the entire macro step by step from Visual Basic
(using F8) it works fine. What could be the problem? What is the
solution.:


Workbooks.Open Filename:="C:\Data\GLIF\2148.xls"
Windows("2148.xls").Activate
Application.Run "2148.xls!NextDay"
ActiveWorkbook.Save
ActiveWorkbook.Close


NextDay macro is as under:

Sub NextDay()

Sheets("Summary").Select

Columns("H:H").Select
Application.CutCopyMode = False
Selection.Insert Shift:=xlToRight
Range("C6:C45").Select
Range("C45").Activate
Selection.Copy
Range("H6").Select
ActiveSheet.Paste
ActiveWorkbook.Save

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help:Running a macro in one excel workbook from another workbook 3
Problems in running a macro in another workbook 3
Filename Problem In a Macro 4
Paste Filtered Range to New Workbook- AS 2
Opening a Workbook with a Macro 4
Macro to Close a specific workbook. 1
Macro stop if file in use by other user? 5
Copying selected rows to a new workbook 0

Top