VBA是插入到Office应用程序中的一个Windows构件,利用VBA编程可实现Office组件内对象的互相插入和调用.下面是用VBA编写的三个用于PowerPoint的过程,可将用户选择的Excel图表文件作为一个嵌入的对象插入PowerPoint幻灯片中.Sub insertEx...VBA是插入到Office应用程序中的一个Windows构件,利用VBA编程可实现Office组件内对象的互相插入和调用.下面是用VBA编写的三个用于PowerPoint的过程,可将用户选择的Excel图表文件作为一个嵌入的对象插入PowerPoint幻灯片中.Sub insertExcelCharttoPowerPoint ODim oPowerPoint As New PowerPoint. Application Dim oPres As New PowerPoint. Presentation Dim oSlide As New PowerPoint. Slide Dim sgBottom As Sinele Dim Excelobj As Shape Set oPres == oPowerPoint. Presentation. Add ‘增加一个演示文稿Set oSlide = OPre. Slide. Add ( 1, ppLayoutTitleOnly)‘增加一个幻灯片With. oSlide. Shapes. Placeholders (1)展开更多
文摘VBA是插入到Office应用程序中的一个Windows构件,利用VBA编程可实现Office组件内对象的互相插入和调用.下面是用VBA编写的三个用于PowerPoint的过程,可将用户选择的Excel图表文件作为一个嵌入的对象插入PowerPoint幻灯片中.Sub insertExcelCharttoPowerPoint ODim oPowerPoint As New PowerPoint. Application Dim oPres As New PowerPoint. Presentation Dim oSlide As New PowerPoint. Slide Dim sgBottom As Sinele Dim Excelobj As Shape Set oPres == oPowerPoint. Presentation. Add ‘增加一个演示文稿Set oSlide = OPre. Slide. Add ( 1, ppLayoutTitleOnly)‘增加一个幻灯片With. oSlide. Shapes. Placeholders (1)