+ Reply to Thread
Results 1 to 6 of 6

PowerPoint interop without showing the PowerPoint application window

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Berlin, Germany
    MS-Off Ver
    MS Office 2010
    Posts
    5

    PowerPoint interop without showing the PowerPoint application window

    Dear all,

    I am trying to create a PowerPoint presentation from some Excel data (basic interop stuff). Everything works fine, however, for large presentations, I can see all the changes in PowerPoint happening live. Therefore, I've tried to keep PowerPoint hidden until the macro is finished. I've used the following code:

    Please Login or Register  to view this content.
    During execution of the second line, I get the following error from the PowerPoint application (error handling in Excel VBA is not triggered):

    Error.png

    This only happens when using WithWindow:=msoFalse.

    Does anyone know how to solve this?

    Thanks heaps in advance!

    Best,
    Philipp

  2. #2
    Registered User
    Join Date
    08-06-2013
    Location
    Berlin, Germany
    MS-Off Ver
    MS Office 2010
    Posts
    5

    Re: PowerPoint interop without showing the PowerPoint application window

    ...anyone?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: PowerPoint interop without showing the PowerPoint application window

    You can not automate Powerpoint without the application being visible.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    08-06-2013
    Location
    Berlin, Germany
    MS-Off Ver
    MS Office 2010
    Posts
    5

    Re: PowerPoint interop without showing the PowerPoint application window

    Andy,

    Thank you for the answer.

    What is the point of the "WithWindow" option then? Is there any use for this? Any workaround for the problem?

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: PowerPoint interop without showing the PowerPoint application window

    Not sure what use that argument is. Why would you want to open a ppt file without being able to see it?

    Is the actual application visible? Your code does not explicitly make it so.
    What about mimiziing either the presentation or the application rather than making it invisible.

    Not aware of any work arounds.

  6. #6
    Registered User
    Join Date
    08-06-2013
    Location
    Berlin, Germany
    MS-Off Ver
    MS Office 2010
    Posts
    5

    Re: PowerPoint interop without showing the PowerPoint application window

    The idea is to do all the work in the presentation (creating slides, copying data) before making it visible (I have an appPowerPoint.Visible = True later on in the code). That way, user input on the unfinished presentation (which can cause errors) is avoided.

    I have found a workaround in the meantime - if another presentation is open in the same powerpoint application, it is possible to open a new presentation without a window (WithWindow:=False) and then work on it. This should do the trick unless the user closes the PowerPoint application. However, it would still be better to only have the PowerPoint application visible after everything is ready.

+ 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. Replies: 13
    Last Post: 01-11-2013, 04:46 PM
  2. 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
  3. PowerPoint
    By khalid79m in forum Excel General
    Replies: 0
    Last Post: 04-10-2007, 11:14 AM
  4. Deploying a application which uses Excel primary interop assemblie
    By Ajey Ayachit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2005, 07:10 AM
  5. [SOLVED] filter arrows showing when copy and paste to powerpoint
    By confused in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-11-2005, 08:30 AM

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