View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default changing views from outlok to excel VB Help


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