asked on

Focus between Excel and Word

Why can't I seem to set the focus between Word97/2000 and Excel97/2000? Some times the programs will get focus but not become topmost other times no focus is granted. How can I consistantly cycle between the two applications?

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

WolfgangKoenig

You can do like something:
MyExcelApp.Visible = True
-> This take the focus on it

MyExcelApp.WindowState = xlMaximized
-> This maximize the application window

TimCottee

WolfgangKoenig, please read the guidelines on comments vs answers at the bottom of this page. I know that you have been warned once at least already in respect of your use of the answer option. If you continue to do so I will report your account to customer services. There are currently at least three questions locked due to your behaviour.

kodiakbear

WolfgangKoenig,
You will find that most experts here will generally post comments instead of answers in order
to keep the question in the high traffic "questions awaiting answers" section.
There is no penalty to you, as the questioner can accept any comment as an answer.
You don't see the accept comment as answer but the person posting the question can.

Also, please note that an 'answer' is supposed to be 100% sure to fix the problem.
Please see:
https://www.experts-exchange.com/jsp/cmtyExpertsOnly.jsp
Please propose an "Answer" only when you are sure it will 100% solve the questioner's problem,
and is the one and only possible solution for the problem,
and doesn't duplicate a previous comment.

It is difficult for Experts to find questions in need of answers when members interested in
only obtaining points have locked questions.
See the Tips on Comments and Answers at the bottom of the page.

kb
Community Support Moderator
Experts Exchange

I am rejecting your proposed answer because of the previous sited reasons. Welcome to EE, you will find it is a very great place to find and give help in a collaborative way

rb982996

ASKER

angelIII, sorry I have been away for a bit. I've used the appactivated method before but using the getobject is new to me. I will try this when I get home from work.