Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using Excel VBA to send email in Outlook. Due to work security restrictions, I cannot bypass the Outlook warning where the user has to select 'yes' to send the message. I have learned to live with that, but once the user selects yes, how can I force the focus back to Excel?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could try a line

    AppActivate "Microsoft Excel"

    Otherwise, instruct the user to use Alt+Tab.


  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    You could try a line

    AppActivate "Microsoft Excel"

    Otherwise, instruct the user to use Alt+Tab.
    AppActivate "Microsoft Excel" - does not seem to want to work for me

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    It's Alt+Tab then...


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •