Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with Excel Charts
Hi, All Experts
I tried run Power Point and paste on it some Charts from excel with this code. Something is wrong and I don't what is. Thanks for your expert advice Sub RunPowerPoint_Automation() Dim PowerApp As PowerPoint.Application Dim PowerPres As PowerPoint.Presentation Set PowerApp = CreateObject("PowerPoint.Application") Set PowerPres = PowerApp.Presentations.Open _ ("C:\PowerTest.ppt") PowerApp.Visible = True PasteCharts Set PowerApp = Nothing End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with Excel Charts
Fernando -
Which line gives you the error? What is the error message? What doesn't happen that you expected to happen? Is the error in the PasteCharts routine? I have some hints on this topic he http://www.geocities.com/jonpeltier/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Fernando Ortiz wrote: Hi, All Experts I tried run Power Point and paste on it some Charts from excel with this code. Something is wrong and I don't what is. Thanks for your expert advice Sub RunPowerPoint_Automation() Dim PowerApp As PowerPoint.Application Dim PowerPres As PowerPoint.Presentation Set PowerApp = CreateObject("PowerPoint.Application") Set PowerPres = PowerApp.Presentations.Open _ ("C:\PowerTest.ppt") PowerApp.Visible = True PasteCharts Set PowerApp = Nothing End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with Excel Charts
Thanks Jon
This Excel macro try run Power Point and open Especific Presentation. In this presentation paste some Excel´s charts I work with Excel 2000 with Win XP When the macro runs stop in the line Set PowerPres = PowerApp.Presentations.Open _ ("C:\PowerTest.ppt") And prompt error like this "Presentations(Unknow member): Invalid request. The Power Point Frame Window does no exist" In a Microsoft Site I found this Excel macro code to automatized Word from Excel Sub RunWordMacro_Automation() Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Open _ ("C:\Wordtest.doc") WordApp.Visible = True WordApp.Run "macro1" ' Uncomment the next line of code to print the document. ' WordDoc.PrintOut Background:=False ' Uncomment the next line of code to save the modified document. ' WordDoc.Save 'WordApp.Quit SaveChanges:=wdDoNotSaveChanges Set WordApp = Nothing End Sub This macro works fine and I try build a similar macro for work with Power Point Thanks a lot for your expert advice Regards, Fernando Ortiz "Jon Peltier" escribió en el mensaje ... Fernando - Which line gives you the error? What is the error message? What doesn't happen that you expected to happen? Is the error in the PasteCharts routine? I have some hints on this topic he http://www.geocities.com/jonpeltier/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Fernando Ortiz wrote: Hi, All Experts I tried run Power Point and paste on it some Charts from excel with this code. Something is wrong and I don't what is. Thanks for your expert advice Sub RunPowerPoint_Automation() Dim PowerApp As PowerPoint.Application Dim PowerPres As PowerPoint.Presentation Set PowerApp = CreateObject("PowerPoint.Application") Set PowerPres = PowerApp.Presentations.Open _ ("C:\PowerTest.ppt") PowerApp.Visible = True PasteCharts Set PowerApp = Nothing End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with Excel Charts
Hi Fernando,
Powerpoint needs to be visible, otherwise things start failing. From your original code snippet move the line PowerApp.Visible = True before the Open() command. Fernando Ortiz wrote: Thanks Jon This Excel macro try run Power Point and open Especific Presentation. In this presentation paste some Excel´s charts I work with Excel 2000 with Win XP When the macro runs stop in the line Set PowerPres = PowerApp.Presentations.Open _ ("C:\PowerTest.ppt") And prompt error like this "Presentations(Unknow member): Invalid request. The Power Point Frame Window does no exist" In a Microsoft Site I found this Excel macro code to automatized Word from Excel Sub RunWordMacro_Automation() Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Open _ ("C:\Wordtest.doc") WordApp.Visible = True WordApp.Run "macro1" ' Uncomment the next line of code to print the document. ' WordDoc.PrintOut Background:=False ' Uncomment the next line of code to save the modified document. ' WordDoc.Save 'WordApp.Quit SaveChanges:=wdDoNotSaveChanges Set WordApp = Nothing End Sub This macro works fine and I try build a similar macro for work with Power Point Thanks a lot for your expert advice Regards, Fernando Ortiz "Jon Peltier" escribió en el mensaje ... Fernando - Which line gives you the error? What is the error message? What doesn't happen that you expected to happen? Is the error in the PasteCharts routine? I have some hints on this topic he http://www.geocities.com/jonpeltier/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Fernando Ortiz wrote: Hi, All Experts I tried run Power Point and paste on it some Charts from excel with this code. Something is wrong and I don't what is. Thanks for your expert advice Sub RunPowerPoint_Automation() Dim PowerApp As PowerPoint.Application Dim PowerPres As PowerPoint.Presentation Set PowerApp = CreateObject("PowerPoint.Application") Set PowerPres = PowerApp.Presentations.Open _ ("C:\PowerTest.ppt") PowerApp.Visible = True PasteCharts Set PowerApp = Nothing End Sub -- Cheers Andy http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
trouble with excel | Excel Discussion (Misc queries) | |||
Excel trouble | Excel Discussion (Misc queries) | |||
Charts/ Graphs and Dates Trouble | Charts and Charting in Excel | |||
Charts/ Graphs and Dates Trouble | Excel Discussion (Misc queries) |