Trouble with Excel Charts

  • Thread starter Thread starter Fernando Ortiz
  • Start date Start date
F

Fernando Ortiz

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
 
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
 
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 said:
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top