Prev: Adding ws information to cell in new wb & saving with ws name
Next: Data Entry Form questions
From: GEdwards on 13 Apr 2010 22:20
That was it. I did not activate WB2 within my sort.

Thanks for giving my head a shake!

"Gord Dibben" wrote:

> I removed only one single quote.
>
> Post your SortList code.
>
> Is there anything in there that activates WB2 so the sort can be done on
> activeworkbook sheet "All Invoices"
>
>
> Gord
>
>
> On Tue, 13 Apr 2010 16:43:01 -0700, GEdwards
> <GEdwards(a)discussions.microsoft.com> wrote:
>
> >By removing the single quotes as suggested results in the following error;
> >
> > Run-time error '1004':
> > The macro 'Master Invoice List.xls!SortList' cannot be found.
> >
> >By leaving the code as I had it originally continues with the following
> >actions;
> >
> >1. The macro CloseXLS in WB1 issues Application.Run "'Master Invoice
> >List.xls'!SortList"
> >2. CloseXLS in WB1 opens WB2 as required
> >3. When using DEBUG, the active workbook is still WB1, but it runs the
> >SortList macro on WB1 and not WB2 as I require it to be.
> >
> >Once the SortList macro finishes I then need to return control back to the
> >initial macro CloseXLS in WB1 to complete its work.
> >
> >
> >
> >"Gord Dibben" wrote:
> >
> >> "not work" means what?
> >>
> >> Error or nothing?
> >>
> >> Try Application.Run "Master Invoice List.xls!SortList"
> >>
> >> Note the removed single quote.
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Tue, 13 Apr 2010 13:17:02 -0700, GEdwards
> >> <GEdwards(a)discussions.microsoft.com> wrote:
> >>
> >> >I have searched through many examples but cannot locate what I need.
> >> >
> >> >1) I have a file "Invoice Template.xls" (WB1). Within it is a sheet named
> >> >"Invoice".
> >> >2) I have a file "Master List.xls" (WB2). Within it is a sheet named "All
> >> >Invoices".
> >> >
> >> >From a macro called CloseXLS in WB1, I need to run a macro in WB2 called
> >> >SortList. This must sort the "All Invoices" sheet within WB2. I then need
> >> >to return control back to the initial macro CloseXLS to complete its work.
> >> >
> >> >Within my CloseXLS macro I have tried the code...
> >> >
> >> > Application.Run "Master Invoice List.xls'!SortList"
> >> >
> >> >I cannot get it to work.
> >> >
> >> >I am not worried about the sort code just how to call from the WB1 macro to
> >> >execute another macro in WB2 against WB2.
> >> >
> >> >How can this be accomplished?
> >>
> >> .
> >>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Adding ws information to cell in new wb & saving with ws name
Next: Data Entry Form questions