One way to get started on this is to record a macro in PowerPoint where you
are adding a textbox with some text in it to a slide
I tried this and this was the code (VBA)
ActiveWindow.Selection.SlideRange.Shapes.AddTextbox(msoTextOrientationHorizo
ntal, 72#, 120#, 540#, 36#).Select
ActiveWindow.Selection.ShapeRange.TextFrame.WordWrap = msoTrue
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=1,
Length:=0).Select
With ActiveWindow.Selection.TextRange
.Text = "Some Song Title"
With .Font
.Name = "Times New Roman"
.Size = 24
.Bold = msoFalse
.Italic = msoFalse
.Underline = msoFalse
.Shadow = msoFalse
.Emboss = msoFalse
.BaselineOffset = 0
.AutoRotateNumbers = msoFalse
.Color.SchemeColor = ppForeground
End With
End With
ActiveWindow.Selection.Unselect
Basically what you have here is the base code to add a textbox to a blank
slide, position it and add some text to it. Where the text is being added,
you read data from your database and output that text.
I am assuming there is going to be some standard format to all the
presentations, the only change being the text displayed. You can have the
slides created with the textboxes and simply set the text based on some
initial selection from the user (song name or some such).
This is not a complete solution to your problem but should point you to the
right direction.
Start of simple first. Forget about reading from a database for the moment.
First get dynamic slides created. Once you have that working move on to
retrieving the text from the database and displaying on trhe slides.
Navin
-----Original Message-----
From: James [mailto:[EMAIL PROTECTED]
Sent: Friday, 27 August 2004 04:58
To: 'redhat'; 'mysql'
Subject: RE: PowerPoint and mysql
I didn't look on the net, I used PowerPoint, to come to this conclusion:
Now, I'm not sure of your office install, so let me summarize what I
have installed:
Office XP fully patched, when I installed it, I installed everything
except ms office toolbar and the stupid paperclip ;^D
Ok, inside PowerPoint, I went to Tools-->Macro-->Visual Basic Editor
This opens up a new window (vb editor)
>From here I deduced that you can access slide properties (hit F2, then
where it says "<All Libraries>" there is a thing there that says
"PowerPoint") that you can set the slide(s) properties, ie: text,
location of text boxes, etc. I am no way able to help you with this
part, I try to steer clear of Office and DB's (other than access).
Access may work, but again, I'm a VB programmer, and I steer clear of
using any office type dependencies. I have done large display news
tickers where they would in effect take over a screen, read information
from a DB and post the information on a Label in a Form. There was also
a separate app that did the updating of the db.
Sorry I couldn't give you a definite How-To, but this is the best advice
I can give.
Thanks,
James
-----Original Message-----
From: redhat [mailto:[EMAIL PROTECTED]
Sent: Friday, August 27, 2004 4:36 PM
To: mysql
Subject: RE: PowerPoint and mysql
On Fri, 2004-08-27 at 15:06, James wrote:
> Looking quickly at PowerPoint, you *can* do what you want to do,
> however, here's the catch, there is no quick way to pull from a file
or
> data source and have it write to the field in pp. You can do some VB
> trickery with the built in VBA in it, where you can use the MySQL ODBC
> driver and could read from a db and write to the screen. Another
> (probably better) way would have a standalone app read the db, and
with
> some GUI (could be VB) take over the screen (such as pp does) and
> display the music. I'm not sure how your church is setup with the pp
> presentation, but these are my initial thoughts on the matter. I
realize
> you aren't a programmer, however, from a quick run through, I don't
see
> a way to do what you are asking with out any programming.
> MSQuery is a program that usually comes with office that allows you to
> connect to db's inside of office apps.
> A DSN is a way for programs to connect to DBs (simple description).
You
> can setup DSNs in systems under Data Sources (ODBC) under
administrative
> tools (windows 2k/xp).
> HTH
>
> Thanks,
> James
>
>
> -----Original Message-----
> From: redhat [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 27, 2004 3:45 PM
> To: mysql
> Subject: RE: powerpoint and mysql
>
> On Fri, 2004-08-27 at 14:30, Victor Pendleton wrote:
> > How did you plan on using the information pulled from the database?
If
> you
> > are currently using MS Query or a DSN you can modify the current
> connection
> > information to point to your MySQL database.
> >
> > -----Original Message-----
> > From: redhat
> > To: mysql
> > Sent: 8/27/04 2:21 PM
> > Subject: powerpoint and mysql
> >
> > Greetings,
> > I'm new to the list.
> > I was wondering if it is possible to user mysql and powerpoint? I
> have
> > a small database of simple text entries that I want to create
whereby
> I
> > can pull a title up and have the rest of the slide dynamically
> > generated. The reason for this is that the presentation data will
> > change weekly but over time the data will be used over and over - so
I
> > don't want to lose it or have to re-enter it. Any ideas?
> > thanks,
> > Doug
> That is part of the equation. I know that in ppt I can add "objects"
> but I don't see anywhere for any kind of datasource. I didn't know if
> anyone was working on a possible plugin or maybe knew of a way to make
> it work. Here's what I am doing. I handle all of the music at my
> church. Every week we use a projector and a laptop to put the words
to
> the songs on a screen. I am taking the task of putting the songs on
the
> laptop and realized that for the past two years they were creating new
> presentations for each week. I think this is a waste of time. At a
> bare minimum I am going to dump all of the songs into some sort of
text
> document in a single directory - named by the title of the song. I
use
> mysql (I'm not a programmer) on some very simple php/mysql stuff at
work
> and am familiar with inputting data and then retrieving it again. If
I
> could have a db with just two columns (title, song) I and a way to
> actually "import" this data to ppt I could make it work. In a perfect
> world I would create a much larger db with song keys, dates of last
> play, etc. I hope this clears my request up. As for "MS Query" or
> "DSN", I don't use MS Query (not sure what it is) and I have no clue
> what DSN is either. Sorry. Thanks for the input.
> Doug
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Thanks for the info. What resource did you use to come up with this
information - can you share that? I suppose it may be worth checking to
see if Access might work more readily than mysql?? I have limited
exposure to Access and don't really like it but it may be an easier
route?? I would like to view your resources though.
thanks,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
