Best approach?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have about 24 slides with Charts that are edited programmatically
from an Access DB. I am trying to determine the best way to fill additional
slides with reports from Access. The presentation generation is done monthly
and the length of the reports varies each time. I do not know if I should be
trying to generate snapshot files or sending the report to excel or as html
and then bring it into powerpoint. The problem seems to be that I can not
determine how to split the report to fit onto the slides, as it does vary in
length. What is the best way to do this? Can it be done using VBA or does it
have to be done manually? Any examples?

Thank you for any help.
 
I currently have about 24 slides with Charts that are edited programmatically
from an Access DB. I am trying to determine the best way to fill additional
slides with reports from Access. The presentation generation is done monthly
and the length of the reports varies each time. I do not know if I should be
trying to generate snapshot files or sending the report to excel or as html
and then bring it into powerpoint. The problem seems to be that I can not
determine how to split the report to fit onto the slides, as it does vary in
length. What is the best way to do this? Can it be done using VBA or does it
have to be done manually? Any examples?
Click to expand...

It'd be worth having a look at this:

Where it starts: the DisplayData project by Naresh Nichani
http://www.rdpslides.com/pptfaq/FAQ00784.htm

It includes routines that extract data from an Access database and covert to
tables in PPT. The conversion may need some tweaking depending on your specific
needs, but the code already breaks the data into multiple slides as needed.

Should get you well on your way ...
 
Thank you. This example looks like it will probably help me out. It won't
be quite as pretty as a formatted access report, however, I think the user
will be happy that the data comes in and will be somewhat formatted. It's
ashame that the users don't know how much effort goes into the magic action
of a button.
Bill W.
 
Back
Top