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?
rb982996Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
What method did you use?
In VB, my favorite is the AppActivate method:

Dim objWord as Object
set objWord = GetObject(,"Word.Application")
AppActivate objWord.Caption

(same for Excel)

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

MyExcelApp.WindowState = xlMaximized
-> This maximize the application window
0
 
TimCotteeHead of Software ServicesCommented:
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.
0
 
kodiakbearCommented:
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:
http://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
0
 
rb982996Author Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.