changing views from outlok to excel VB Help
 

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

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

changing views from outlok to excel VB Help
 

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