F
Fernando Ortiz
Hi Experts
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
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