changing views from outlok to excel VB Help

[Rivers]

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

 

[Tom Ogilvy]

Try this:

AppActivate Application.Caption

 

[Rivers]

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