Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

i want to export qlikview objects to existing powerpoint using macros

i have seen the posts where it will create a new powerpoint and export to that but, I want to export the qlikview tables to an existing powerpoint file using macros. how i can do that? can anyone help me?

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

This code will open an existing PPT file and get an object for slide1. Use the same code for exporting tables to new ppts to export to this existing ppt.

Set PPApp = CreateObject("Powerpoint.Application")

PPApp.Visible = True

Set PPPres = PPApp.Presentations.Open("YourPPTPathandFile.potx")

Set PPSlide = PPPres.Slides(1)

View solution in original post

2 Replies
m_woolf
Master II
Master II

This code will open an existing PPT file and get an object for slide1. Use the same code for exporting tables to new ppts to export to this existing ppt.

Set PPApp = CreateObject("Powerpoint.Application")

PPApp.Visible = True

Set PPPres = PPApp.Presentations.Open("YourPPTPathandFile.potx")

Set PPSlide = PPPres.Slides(1)

udaya_kumar
Specialist
Specialist
Author

thanks for the help mwoolf