Hi all just a quick question

i have a macro that runs an outlok query within excel this macro runs fine
but i need the macro to rechange the view from moving the view from excel to
outlook i need it to change back to the excel workbook which started the
macro. ive tried
workbook("Original.xls").activate but nothing happens

any ideas?


thanks

Rivers

Try this:

AppActivate Application.Caption


--
Regards,
Tom Ogilvy

"Rivers" wrote:

> Hi all just a quick question
>
> i have a macro that runs an outlok query within excel this macro runs fine
> but i need the macro to rechange the view from moving the view from excel to
> outlook i need it to change back to the excel workbook which started the
> macro. ive tried
> workbook("Original.xls").activate but nothing happens
>
> any ideas?
>
>
> thanks
>
> Rivers
>

hi tom this still does not work it seems like its locked on outlook when
running the macro

"Tom Ogilvy" wrote:

>
> Try this:
>
> AppActivate Application.Caption
>
>
> --
> Regards,
> Tom Ogilvy
>
> "Rivers" wrote:
>
> > Hi all just a quick question
> >
> > i have a macro that runs an outlok query within excel this macro runs fine
> > but i need the macro to rechange the view from moving the view from excel to
> > outlook i need it to change back to the excel workbook which started the
> > macro. ive tried
> > workbook("Original.xls").activate but nothing happens
> >
> > any ideas?
> >
> >
> > thanks
> >
> > Rivers
> >