Results 1 to 4 of 4

Thread: Activating Applications

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2005
    Posts
    1

    Activating Applications

    How do I reliably switch between Office applications using code? I have an excel workbook that when opened goes to full screen mode, opens other workbooks and then starts a powerpoint slideshow. I wish to be able to press a button on the slideshow that switches to one of the workbooks (that is still in full screen mode) and then press a button on Excel to get back to the presentation. I used to use a Hyperlink in Powerpoint to achieve this but on my latest machine (windows XP) this causes another instance of excel to be started. I have tried using API calls to get the window handle of excel and then bring that window to the front but it does not always work.

    Is there an easy way to identify and office window and then show it?

    Thanks

    Mike Selby

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Activating Applications

    Welcome To the Forums.

    The issue may be that you need to minimize the full screen pp presentation first and then activate the excel app all in the same procedure in PP.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3
    Junior Member
    Join Date
    May 2005
    Location
    Trenton, Ga
    Posts
    24

    Re: Activating Applications

    this might sound a little silly, but cant you just use the Alt-Tab and Shift-Alt-Tab?
    If at first you don't succeed, deny you ever tried.

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Activating Applications

    If you can, you may not want to since the dialog window for the switching of windows by tab will momentarily be shown.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width