Switch focus back to Excel from Outlook

[amphinomos]

Hi,

I'm using Excel to import mails from Outlook into a spreadsheet. Code works fine but I'd like to switch the focus between the windows so the user understands what's going on. Here's my code :

Please Login or Register  to view this content.

The visible method shows Outlook but I would like to only show the PickFolder box on top of Excel. Then I've tried using olApp.Visible = False, AppAtivate("Microsoft Excel"), olApp.WindowState = olMinimized but none of these work or have the intended effect.

Any ideas ?

Thanks,
amphi

[michson]

Hi,

Let's try WScript.

Please Login or Register  to view this content.

[amphinomos]

Thanks michson. (Discover new things everyday). Won't running a script to an already open application interfere with them though ?

[amphinomos]

After googling around this is where I've gotten to :

Please Login or Register  to view this content.

Is there any way to activate the workbook my procedure is running on ? Right now it's maximizing the Excel application with no workbooks showing.

[romperstomper]

Did you try just using

Please Login or Register  to view this content.

after your original code?

[amphinomos]

I did but with varying results. In addition this doesn't show Outlook when I call the PickFolder method.