I just reread my response and it assumes taht you have a certian amount of
understanding. If you are a little lost in the technical details reply back
and I will give you some better pointers.
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

> Here is a very basic example. It modifies a workbook called That.xls. It
> first checks if the book is open. if not it opens it. There is a workbook
> object called wbkTarget that gives you a reference to the workbook we are
> manipulating. The code is running in "ThisWorkbook".
>
> Sub ModifyOtherBook()
> Dim wbkTarget As Workbook
>
> On Error Resume Next
> Set wbkTarget = Workbooks("That.xls")
> On Error GoTo 0
>
> If wbkTarget Is Nothing Then Workbooks.Open ("C:\That.xls")
>
> wbkTarget.Sheets("Sheet1").Range("A1").Value = "Tada"
> End Sub
> --
> HTH...
>
> Jim Thomlinson
>
>
> "LPS" wrote:
>
> > Hi Jim. Thank you for such a fast response. I want to be able to manipulate
> > a second workbook from a macro I start in the first workbook. It doesn't
> > matter where the execution ends.
> > --
> > LPS
> >
> >
> > "Jim Thomlinson" wrote:
> >
> > > Yes...ish but we need a little more clarification. Do you want to
> > >
> > > 1. manipulate another workbook
> > > 2. run code that exists in another workbook
> > >
> > > Bare in mind the the thread of execution will always end in the workbook
> > > that began the process, but that workbook does not need to be the active
> > > workbook when the code ends.
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "LPS" wrote:
> > >
> > > > Using Excel 2000 can you create a macro that works across more than one
> > > > workbook? For example, can a macro start running in one workbook and finish
> > > > in another? If so, is there any special code or actions you need to do to
> > > > make it work?
> > > >
> > > > Thanks,
> > > > --
> > > > LPS