RSS Forums RSS

VB 6.0 + POWERPOINT automation

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Reply
Posts: 191
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

VB 6.0 + POWERPOINT automation

  #1  
Nov 27th, 2008
I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added in the already existing PPT as extra slides.

Please suggest me how to change this code so as to add the slides in the already generated powerpoint with data generated.

Dim ss As DAO.Recordset
Dim DB As Database
Dim query As String
Set DB = CurrentDb()
query = "select title from tbl_weight_technical where database_id = " & dbId
Set ss = DB.OpenRecordset(query, dbOpenSnapshot)
If ss.RecordCount = 1 Then
Dim path As String
Dim ppApp As Object
Set ppApp = CreateObject("PowerPoint.Application")
path = GetdbPath & "main_pic\template.ppt"
ppApp.Visible = True
Dim ppPres As Object
Set ppPres = ppApp.Presentations.Open(path, False, True, True)
Dim ppSlide1 As Object
Set ppSlide1 = ppPres.Slides(1)
Dim ppShape1 As Object
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Other Threads in the Visual Basic 4 / 5 / 6 Forum
Views: 629 | Replies: 0 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 2:36 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC