+ Reply to Thread
Results 1 to 2 of 2

Switch from powerpoint to excel and then back again

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    Connecticuit
    MS-Off Ver
    2010
    Posts
    4

    Switch from powerpoint to excel and then back again

    Hello,

    I am trying to create a command button using a macro in power point which when clicked will:

    Open a specific sheet on a workbook in excel and display that for 30 seconds, then switch to power point and activate that presentation.

    I have figured out how to do the timing with various loops. I am just not sure how to switch between two active applications, more specifically how to switch to an excel docs specific sheet from powerpoint.

    Any help would be much appreciated!

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,150

    Re: Switch from powerpoint to excel and then back again

    If I understood correctly, it could be something like that:
    Please Login or Register  to view this content.
    There must be selected a reference to "Ms Excel Object Library" (Tools/References).
    With other timing functions, e.g. 'timeGetTime()', will be better.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Switch focus back to Excel from Outlook
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2015, 06:45 AM
  2. do this everytime I switch back to excel window in OS
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2014, 02:26 PM
  3. [SOLVED] Code to switch from excel to powerpoint
    By freddiethomas in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-12-2012, 11:35 AM
  4. Data input in powerpoint to select data in excel and report back to powerpoint
    By daveybright in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2009, 09:54 PM
  5. Getting excel to switch back to a workbook?
    By cuewoz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-25-2009, 05:51 AM
  6. [SOLVED] How do I switch openoffice back to excel
    By Bill9669 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2006, 07:00 PM
  7. Can I switch back to Excel sheet while a form is shown?
    By Ai_Jun_Zhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2005, 08:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1