Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom views in excel keep changing | Excel Discussion (Misc queries) | |||
outlok today [ display name ] | Excel Discussion (Misc queries) | |||
"custom Views", column widths not changing | Excel Discussion (Misc queries) | |||
Changing pivot table views with a macro | Excel Programming | |||
changing pivot table views with a macro | Excel Programming |