locked
Hide Excel from popping out when creating slide in PowerPoint RRS feed

  • General discussion

  • Hi, l have an application that will generate PowerPoint and create some chart within the PowerPoint.

    i've been using Interop.Powerpoint.Slide.Shapes.AddChart() to create chart in PowerPoint. The momment this function is called, an Excel window will pop out for us to fill in the data. Is there any way to tell Excel window open in minimize mode/behind other application instead of popping out and became the active window? Even if I doChart.ChartData.Workbook.Application.Visible = false, Excel window still shows up a little while. Some of the device the Excel window will automatically open behind other application but some don't.

    Tuesday, January 27, 2015 7:30 AM

All replies

  • Hello,

    Have you tried opening the excel before Powerpoint does: you could open all the needed excel first in background.

    I assume in that powerpoint will not reopen it?

    Best regards,

    Wouter

    Tuesday, January 27, 2015 10:59 AM
  • I guess open excel first in background won't work. When we call AddChart() method, an Excel will be pop out for us to fill in the data. By the way, the Excel will be close after a chart is created successfully and another new Excel Window will pop out again if we call AddChart() method again.


    • Edited by Lee Kenvin Tuesday, January 27, 2015 12:58 PM
    Tuesday, January 27, 2015 12:53 PM