Is it practical/possible?

  • Thread starter Thread starter rob
  • Start date Start date
R

rob

Hey folks,

My office uses a query that lists all of the active evaluation reports we
are currently working on (Let's say we have an average of 25 active
reports).

The info is imported into EXCEL, then inserted into a POWERPOINT
presentation which is part of a weekly staff meeting (Time-Consuming!).

Linking the slide to the EXCEL sheet is sloppy and always require additional
work.

Before I waste my time, is it practicle/possible to write some code
(ACCESS/VBA) that counts the number of records (easy), then imports 8 or
less records into each POWERPOINT slide (either existing slide or created
programmatically)?

I've created slides using vba within POWERPOINT , but never from ACCESS.

Is it practical/possible? Does anyone have any references to point me too
so I don't "reinvent the wheel"

Rob
 
well you can autoimize the import of your EXCEL data and than use the
ms.graph object to view your charts.

henry
 
Hi Rob,

It's possible. I've never tried it myself, but if you know how to use
VBA to create PowerPoint slides and place text on them you're most of
the way there.

The general idea, I think, would be to create a recordset into your
query, and then do something like this pseudocode:

Do Until RS.EOF
Create new slide
For j = 1 to 8 '8 records on slide
Read values from RS.Fields and place them on the slide
RS.MoveNext
Next j
Loop

You can do this either by automating PowerPoint from Access VBA, or
(probably) by writing PowerPoint VBA that uses the DAO library to create
a DBEngine object, open the database and create the recordset.
(Probably, because if it's a parameter query you'll need to work from
within Access.) There are some pages here about automating PowerPoint
and manipulating PowerPoint tables: http://skp.mvps.org/vba.htm. And
there's sample code here
http://word.mvps.org/faqs/interdev/GetDataFromDB.htm that creates a
recordset into a table or query. It's Word VBA but easily converted to
PowerPoint. (But if you're using Office 2000 or later, set a reference
to DAO 3.60, not 3.51.)

If this isn't enough to get you started, post back here.
 
John,

Thank you...

I think it's obvious now that it can be done, I think my real concern is the
format of the EXCEL sheet once it's added into the slide. (have you ever
pasted cells from EXCEL into POWERPOINT? The formatting is always wrong!)

I'll try importing my query from ACCESS (one record/at a time) directly into
POWERPOINT - I should have more control of the formatting using the SHAPES
Collection Object.

If it works, I'll share the code -- allowing other VBA enthusiasts make fun
of my skills, then improve upon the code ;-)

Rob
 
Sounds good. Have you investigated the Table object that's exposed by
recent versions of PowerPoint?
 
No I haven't; I'm using 2003 so I'll look throught the online documentation
and GOOGLE the rest...

Thanks for getting me started in the right direction
 
Back
Top