Visual Basic :: Help VB+PowerPoint

Powerpoint
Through Excel I have opened up a powerpoint presentation. On the powerpoint presentation, slide 3, I want to insert a graph. Therefore, I can easily insert a chart and a datasheet appears. However, I want the figures from my spreadsheet, say sheet1 to be imported onto the datasheet.

Is there a way of doing this?

Any help would be appreciated.

Powerpoint Help
I've got a project that uses an embedded ppt in an excel file. DOes anybody know site similar to this forum that I may go to for help.

THanks

Powerpoint OLE
can anyone tell me how to start a powerpoint slideshow without having to double click it, instead just clicking a command button

Thanx

VB & Powerpoint??
I would like to get some suggestion and advice on this problem below:

I would like to let the user to select the information(from MySQL) to be inserted into a powerpoint slide.

Let's say...i've created a slides(powerpoint) acts as a employee badge card. In the card, it will contain ID, Name,Department, and Photo. One slides represent one card. Therefore, if the user would like to print more than 1 employee badge card, the slides will increase with the same background but different detail(according to the Employee ID).

Can I do something like MAIL MERGE to display the ID, Name, Department and Photo in Powerpoint?

Powerpoint
Hi

i have the code to open a powerpoint presentation from VB and put it on SlideShow.

VB CODE:
-----------------------------------------------------------------------
Private Sub lbltutorial_Click()

'opens powerpoint presentation and puts it on slide show

Set Appt = New PowerPoint.Application
Appt.Activate
Set Pppt = Appt.Presentations.Open(App.Path & "Tutorial.ppt")

Pppt.SlideShowSettings.Run

End Sub

-----------------------------------------------------------------------
What is the command for closing Powerpoint once the user has finished viewing the Slide Show. ie after the last slide is over.

Thanks a lot!!

Powerpoint In VB
Hi
im not sure if this is the right section i should be writing to but anyways...

I have a powerpoint presentation i have created. Is there any way i can open this through Visual Basic 6?

Thanks a lot!

VB And PowerPoint
I have powerpoint presentation opening inside a vb form, it opens in a frame, is there a simple way of controling the presentation

CmdNext
and
CmdPrevious

That once clcked do the required action.

i have asked before and have seen one way which requires you to get the slide id, but is there an easier way.

Thanks
David

Powerpoint In VB
Hi,

I'd like to show a powerpoint presentation in my VB (6) project. Now i know i could use OLE, but when the users of my program haven't powerpoint installed, they can't use it.

I've seen there is a powerpoint viewer, maybe this is a sollution? But i don't know how to implement this viewer into Vbasic.

could somebody help me? i would really appreciate it,
regards, tiem (netherlands... nice english huh )

VB And PowerPoint
Anybody know how to code an ActiveX control and/or ActiveX DLL in VB for PowerPoint? Just looking for someone who has any experience so I can brainstorm with.

Powerpoint And VB
I have seen a good number of threads on VB and powerpoint, but none that answer my questions, so here goes...
I have a VB6 application, and i want to run a small tutorial that I have created in powerpoint. I want it to be available to run on its own, (outside the VB app), and from a button press within VB.
my current non-working method is using the Microsoft PowerPoint Presentation component from within VB. but I can actually get that to play at runtime with a button press. what is the command to actually get it to play?
Also, will this technique prevent me from playing the show standalone? I want it to run from an html help screen as well.

Nice Forum. It's a shame I just found it.

VB In PowerPoint !!!!!
Does anyone knows how to run a VB program in a powerpoint presentation ?
Thank you in advance

PowerPoint VBA
This is my first post, so hello to everyone. I'm also new to VB, so be gentle!

I've done a few slideshows with screen prints to simulate a software programme, with navigation buttons and slide transitions to give the appearance of the live system. (all easily done within PP). However, I want to give an element of interactive and get the user to type into the relevant fields (or transparent VBtextboxes over the screendump!) and go to the next slide if the right information is entered, or a message box if wrong.

I've inserted a Textbox (from the Control Toolbox) and Commandbutton and the code below is what my (limited) learning has produced.

Private Sub CommandButton1_Click()
Dim Tempfile As String

Tempfile = Val(Textbox1.Text)

If Tempfile = Robin Then
SlideShowWindows(1).View.Next
Else
MsgBox "Please type Robin", vbOKOnly
End If

End Sub

The message box appears OK, the issue being that it appears when I type Robin as well!!!

Can anyone help please?

Thanks.
ROBIN.

Powerpoint
Hi there,

I have two questions :

1. Is there someone who have some trouble with powerpoint events? If the user go quick forward or backward some events (slideshownextbuild, slideshownextslide) are never sent.

2. Is there someone who have successed in getting the current animated object in a powerpoint slideshow? The example in the ppt help suppose that the user doesn't go backward. I haven't found a good solution to know the current objet in an animated scene, so I'm trying to hook keyboard and mouse events. Is there a better solution?

I'm using Powerpoint XP under W2K.

Thanks for your help,

Ze Seb

VB And Powerpoint On A Mac
I was wondering if anyone out here knew how to insert VB objects, such as text boxes, into Powerpoint slides. I know how to do it on a PC, but on a Mac it wouldn't work the same. I could create the object but I couldn't figure out how to stick it on a slide. It was very weird. Any suggestions would be lovely. Thanks

HELP - VBA Powerpoint 97
How can I make a Rectangle object move with a Macro ?
I've tried the Macro Recorder without success.
I am trying to write a DEMO Game presentation.

VB & Powerpoint
To All,

I am in need of some advice. There are two things I need to do with PP under VB control. The first is that I have a "Master" presentation set of slides. This presentation contains some number of products, each product consisting of various number of slides. i.e product 1 has 5 slides, product 2 has 20 slides, etc ..

What I initially want to do is, from VB, have the user select a product (or products) from a menu, and then go thru the "Master" presentation and select those slides that relate to that product or products and create a new, custom presentation. At this point there will be no modification of the slide(s) content. I could maintain a list of which slides belong to which product, but I would prefer if somehow the data was kept within the "Master" presentation.

I was thinking of putting a reference to the product (name, number, etc.) into the speaker notes, but I couldn't find a way to read the speaker notes for each slide. Another option, which I don't know if it is doable, is to "name" each slide with the product (name, number, etc) and try and get it from there.

The short of it is that I want to go thru the entire presentation slide by slide, and based upon some "hidden" information, determine if this slide is something I need to include and copy it to a 2nd PP instance.

After I complete this, my next step is to insert slides and change the TEXT on that slide. i.e change customer name, address, presenting rep., etc.

Any thoughts (or code snippets) on how to achieve these tasks would be greatly appreciated.

Thanks in advance,

Jim

VB + Powerpoint
Does anybody know how can I page a powerpoint presentation in a ole control inside a VB form???

Tks.

Powerpoint
I need to change the value of a dim(ed) array from EACH slide.

If I dim an array in the declarations... it dosn't seem to be recognised by the individual slides even if dim(ed) as global/control/integer

Any help appreciated

Paul

VB + Powerpoint
I have a VB project with a powerpoint file embeded in an ole object. I´d like to page the presentation as I select the topics in a treeview control.
Does anyone can help me, please???

Vb And Powerpoint
Here is my chalenge:
I need to develop an object on ppt which I called "phase changing
moon"
It would work like this:
Moon full (as default) --> click the mouse on it --> moon ¾ full -->
click the mouse on on it --> moon ½ full --> click the mouse on it --> moon
¼ full --> click the mouse on it --> moon empty --> click the mouse on
it --> Moon full (back to default).
I´ve got to develop it using Flash...The ploblem is that it only
works in the Presentation Environment and what I´m looking for is to develop
an object and interact with it in the Editing Environment, the creating area
itself.
I guess that maybe it could be made with Visual Basic Programming
but I´m not sure...
Could anyone help me with this??? Is there any VB code for this type
of interactive object???
Thank you very much.
[ ]´s.
Luiz.

VB6 Or Powerpoint
Basically ive a prject to display data on a big screen

also has been mentioned is to display weather or RSS feeds to news

i know in VB6 can add a web browser

but was thinking wud just want a scrolling feed at bottom, cud this be done in powerpoint, just want a proffessional opition

ok thanks in advance

have somethin in powerpoint already just not sure how u can add an internet feed, cheers

VB And Powerpoint
I want to make a powerpoint interactive...basically, answer a yes/no question on the first slide and depending on your answer you are directed to a particular slide. I was looking for advice on how to start.

VB6 And Powerpoint
Anybody know how to change the background color/style for slides in Powerpoint? I didn't see any options. Thanks!!

PowerPoint In VB
This probably isn't the place to ask this but I want to start integrating PowerPoint into VB6. Are there any tutorials that could start me in the right direction?

VBA And PowerPoint
I'm creating a macro in PowerPoint 2002 to automatically format all of the ppt files in a specific directory.

I cannot find a way to programmatically toggle between the tabs on the left tabstrip (Outline/Slide). Any ideas? Either VBA or VB6 help would be great.

Thanks!

Powerpoint VBA
I want for example when the presentation reaches sheet 15 and I hit the mousebutton or another key on the keyboard then a userform has to pop up. When I again hit the mousebutton or a keyboardkey then the presentation has to go on as is normal. How do I do that?

Powerpoint VBA
All,

have some VBA code in powerpoint that I am using to add details to a table that has been created on a slide.

I am wanting to set the fill colour of a cell in that table and I had thought it was working but now every time I run through it doesn't error but it doesn't fill the cell?

I am not sure what is going on so any help here would be appreciated.

VB Code:
If oShp.HasTextFrame Then Set txtRng = oShp.TextFrame.TextRange Set foundText = txtRng.Find(FindWhat:="GREEN", MatchCase:=True, WholeWords:=True) Do While Not (foundText Is Nothing) With foundText ActivePresentation.Slides(1).Shapes(8).Table _ .Cell(valTab, 9).Shape.TextFrame.TextRange.Text = "G" ActivePresentation.Slides(1).Shapes(8).Table _ .Cell(valTab, 9).Shape.TextFrame.TextRange.Font.Bold = True valGreen = valGreen + 1 End With ' This just isn't working and I don't know why? ActivePresentation.Slides(1).Shapes(8).Table _ .Cell(valTab, 8).Shape.Fill.ForeColor.RGB = RGB(0, 100, 0) Exit Do Loop End If

VBA: PowerPoint
Hi all,

I want to put some text before and after the user selected text, in powerpoint. The user can select the text across text frames on a slide. I am using Office 2000. Right now what is happening is whenever i am selecting across text frames, each text frame is becoming a separate slide. How can i handle this?

Regards,
Shivaraj

VBA:PowerPoint
Hi all,
I am trying read the slides of a powerpoint presentation. I want to search for particular words in the powerpoint presentation comprising of 'n' slides. How to read thru the all the slides?

-TIA

Powerpoint In VB
How do I show a powerpoint slide with all animations and stuff on a form? I can show it full screen but I don't want it that way. Somebody help!!??

I Need Help With PowerPoint...
Hi guys, i have a problem.... you see... ihave this slideshow presentation

well its only one slide but this slide has many text boxes.. what i will like to do is that when the mouse pointer goes over any text box, the color of the box will change and when the mouse pointer moves away from the box, it will return to its original color...

this is my first time dealing with something like this in PowerPoint and i have no idea how to start!!! i have try many samples from the web, i modify them but still no luck!!!

can someone help me out????

Using MS PowerPoint From VB???
Does anyone know how I can use VB to controll PowerPoint presintation using code??

E.G. Opening PowerPoint and Creating new slide?

E.G. Creating Text boxes on slides?

E.G. Copying text from a .txt file to a text box in PowerPoint?

E.G. Importing Slides from one Presintation to another?

Thats it for the moment, Please help in anyway that you can

Powerpoint
Here is a good one. I thought I'd take a chance and ask here if this could be done.

In powerpoint, I need to build a custom chart.

The chart must consist of stacked bars and one line the line is negative numbers and the stacked bars are positive numbers.

Currently I can get the stacked bars but I am not able to change the one bar into a line.

Swoozie

VB6 And Powerpoint
I have been asked to put together an application that interacts with an existing powerpoint presentation.
The way it wants to work is that the user can run through the first 6 slides as a normal presentation, then from there a VB application needs to run with various forms etc within it and then to revert back to the presentation for the final set of slides.
My question is, do I run the presentation and then call the VB app or do I make the application run from the beginning calling powerpoint as an object to run within VB ?

If anyone has any thoughts on this please let me know.

Thanks

VBA + Powerpoint
ok heres the scenario, I'm building a little bit of vba into an excel workbook so that when the workbook is closed it will save it as html and then parse the html and add the urls for the webpage instead of the address for the local drive ... however, the changes made in excell also change the html form of the powerpoint document.. I could change this myself, however it doesn't seem to respond in the way that excel would.. for example.

ThisWorkbook.Saved = True
ActiveWorkbook.Save
ActiveWorkbook.SaveAs "d:work emp.html", FileFormat:=xlHtml

Which works quite well, however for powerpoint I would not be able to take this approach because the program would not be open and therefore I wouldn't be able to do a ActivePresentation.Save (assuming that was even legal..)
Can anyone think of anything that would work ?

VBA In Powerpoint
Hello
Yes i have 17 slide presentations in Powerpoint and want one to the background and at the press of a key the corresponding presentation be shown. This way i dont have to fiddle about with changing windows and blacking out the projector...How do i use VBA to do this?

Powerpoint
How do i open a powerpoint App directly from
VB.

Thank you.

Powerpoint OCX
hi all
Does anyone on the list know of a presentation OCX capable of displaying
presentations such as Powerpoint in my programe?

Cheers,
appc

PowerPoint And VB
Should be pretty simple
I need to display text in a textbox on slide 2 when I
type text in a textbox on slide 1.
Also is there something like an 'on open' or 'on load' event
for a particular slide.
I think I've worked out an 'autoexec' function for the
presentation, but not for a given slide.
Thanks in advance

Reg VB And Powerpoint
Hi,
I want to open an existing powerpoint file (i.e .pps) from visual basic .
When i am opening the .pps file, first powerpoint gets loaded
and then the .pps file is displayed.
In this the user can identify in which tool this has made.
So my objective is i don't want the user to know that this is from
powerpoint.how can i do this?

VB6 And Powerpoint
How do I launch a Powerpoint presentation from a VB6 application?

PowerPoint
Hi all. I was wondering if it is possible to play a PP slide show embedded in a VB6 form. If so could someone point me the right direction about how to go about this.....thanks in advance.

Edited by - gavin@adscomm.co.uk on 5/5/2004 8:23:38 AM

Powerpoint & VBA
I would like to insert some VB code as a macro in a PowerPoint presentation.
The code does some string manipulation and this seems to work find. I don't have enough experience to know how to read & write from a file or the console. Can someone show me how I can display a message, gather input from the keyboard and read and write lines from a text file from within a VBA script? Thanks.

Using PowerPoint With VB6
Is there an easy way to embed a PowerPoint show in a VB6 form.

I've got a show I want to present inside my VB program.

I've tried inserting a "PowerPoint Show" as an "Insertable Object" but I cannot seem to link it to an existing ppt file

Cheers

John

Edited by - stocktonlad on 9/21/2006 3:09:42 AM

Powerpoint With VB6
Dear All,

Can anyone tell me how can i open a new Powerpoint presentation and create 5 blank slides in it.

I am able to open it with this peace of code but not able to add slides. It is giving error

Any good tutorial ..... ?

----------------------------------------
Dim pPT As PowerPoint.Application
Dim pPTopen As PowerPoint.Presentation
Dim sl As Slides

Set pPT = New PowerPoint.Application
pPT.Visible = True

Set pPTopen = pPT.Presentations.Add

set pPt = nothing

---------------------------

Thanks in advance

Regards
Amarjit

VB Powerpoint
My final year project, is to create a "Project Mgmt Review" automation tool. Every month, the company I am working for asseses it's monthly performance's in the form of 14 spread sheets which it in turn incorporates into a 20 slide powerpoint. So at the end of every month, the values in the excel spreadsheet changes,which in turn has to be incorporated into the powerpoint PMR. Until I create, this software, At the end of every month , someone will have to manually cut,copy , paste and replace the old excel sheets in the PMR, with the new one. My project is to automate this entire process, with the click of a button.
I would have to generate a mechanism,whereby I can access the Excel spreadsheets using vb, an incorporate them into powerpoint.
Thank you, pinky for yr help. My doubt now is, If and when I use a macro to record and then create a new one, and finally go to the Microsoft visual editor and run, it works fine. However, I am encountering some problem's if I copy the code and paste it in a new VB Project. I would like to know, if it would work in this way or no. Also, If it is given that it is neccesary for me to open the module from powerpoint, in order for it to work, Is there some way that I can directly incorporate this macro in my vb module, which is like a normal vb project with a form...etc.
Thank you

PowerPoint .pps - Need Help
Hi Code Guru Experts,

I am looking for a way to open PowerPoint presentations ( .pps ) in a way that the second presentation will run right after the next one without any delays.

I used the OLE object but there are 2 problems . Solving one of them is good enough.

If I use the following code, I load the first presentation but the OLE1.Close commnad takes about 2 seconds and in that time I see the computer desktop.

OLE2.CreateEmbed ("c:xxx.pps")
if OLE1.AppIsRunning then OLE1.Close
OLE2.DoVerb

If I use the next code, The mouse stays on top of OLE2 Presentation.
This happans from the .close command.

OLE2.CreateEmbed ("c:xxx.pps")
OLE2.DoVerb
if OLE1.AppIsRunning then OLE1.Close

Any Ideas ??

Thanks,

Itay.

PowerPoint
I was wondering if anyone knew how to go about showing a PowerPoint template (.pot) file on a form? I was hoping to show it in a Picturebox or Image or even a browser window. Is there a specific window that will display it? Thanks.

PowerPoint
I have created a PowerPoint presentation (*.ppt), and saved it as a PowerPoint Slide Show (*.pps). I want to create a VB project that will play the (*.pps) file with the Form Load event.

Why?
If I copy the Slide Show (*.pps) file to a CD, I need to play it with the Autorun.inf file. The Autorun.inf file only execute EXE files and not (*.pps) files. If VB can start the slide show, I can save the VB project as an EXE file.

Any help / code will be appreciated.

Thanx

Ivan