We have a daily task that generates a dozen graphs. Each day, we want to display the graphs on a large screen monitor for public viewing, preferably as a slideshow. Currently the graphs come from Access 2003. How can we automate getting the graphs in a format that will work with PowerPoint or some other slideshow software?
Graph slideshow
- Thread starter bobfin
- Start date
R
RaDD
Guest
Sending Charts to PPT
I found the attachment the other day on this board and it seems pretty smooth. I take no credit - just passing it along. Good Luck, Ray
I found the attachment the other day on this board and it seems pretty smooth. I take no credit - just passing it along. Good Luck, Ray
Problem with multiple reports
I tried using the proc in the sample.zip. It successfully creates a PowerPoint file from an Access report. But when I try to create a PPT file from multiple reports, the file only has slides from the last report. The code seems to create a new PPT file everytime it runs. I tried making variations of the procs to append slides to an existing PPT, but so far I've been unsuccessful. Do you have any idea how I can get this approach to put slides from multiple reports into a PPT File?
I tried using the proc in the sample.zip. It successfully creates a PowerPoint file from an Access report. But when I try to create a PPT file from multiple reports, the file only has slides from the last report. The code seems to create a new PPT file everytime it runs. I tried making variations of the procs to append slides to an existing PPT, but so far I've been unsuccessful. Do you have any idea how I can get this approach to put slides from multiple reports into a PPT File?
Problem with multiple reports
I couldn't get the sample.mdb to work. An error message popped up: "Can't find project or library". What did you do to fix this problem? I'm unable to get this to work.
I also have a report with multiple pages and want multiple power point slides. Were you able to solve the problem with multiple rpts?
Thank you.
Dona
I couldn't get the sample.mdb to work. An error message popped up: "Can't find project or library". What did you do to fix this problem? I'm unable to get this to work.
I also have a report with multiple pages and want multiple power point slides. Were you able to solve the problem with multiple rpts?
Thank you.
Dona
I wasn't able to make the code work for multiple reports. The code was just too complex for me to rework. Someone else came up with the idea of using an Access table that has a field defined as an OLE object. Report snapshots can then be used to fill that field. The timer feature in Access can then be used to display the snapshots at regular intervals.
A few minutes ago I accidentally ran into another approach that works for graphs (Knowledgebase article 824276). After adding the Microsoft Graph library to your Access references, you can convert graphs to JPG files with the following code (let Graph1 = the name of the chart on the form or report and C:\Charts = the folder for storing the JPG files):
Public Sub GraphToJpg()
Dim grpChart As Graph.Chart
Set grpChart = Me.Graph1.Object
grpChart.Export "C:\Charts\Graph1.jpg", "JPEG"
Set grpChart = Nothing
Me.Graph1.Action = acOLEClose
End Sub
A few minutes ago I accidentally ran into another approach that works for graphs (Knowledgebase article 824276). After adding the Microsoft Graph library to your Access references, you can convert graphs to JPG files with the following code (let Graph1 = the name of the chart on the form or report and C:\Charts = the folder for storing the JPG files):
Public Sub GraphToJpg()
Dim grpChart As Graph.Chart
Set grpChart = Me.Graph1.Object
grpChart.Export "C:\Charts\Graph1.jpg", "JPEG"
Set grpChart = Nothing
Me.Graph1.Action = acOLEClose
End Sub
Hi,
I've just found this thread, and would like to say it has solved a problem in 10mins that I thought would take me all day to sort out, so many thanks to whoever wrote the code.
In answer to some of the questions,
"I couldn't get the sample.mdb to work. An error message popped up: "Can't find project or library". What did you do to fix this problem? I'm unable to get this to work."
Make sure you have the powerpoint library selected in your references.
In the code window click tools / references (the code must not be running foe this to be available) and see if you have a reference marked as missing.
If so deselect this (it is probably for a diffferent version) and scroll down the list until you see the microsoft powerpoint dll and select this one.
I't worked for me then.
I used the code by just passing it the name of my report, without any template or slide number and it worked fine, multiple pages in my report came out as multiple slides just as I wanted.
Without giving the report a name it just opened powerpoint as a new presentation for each report I exported, so I could save or move slides around as I wanted.
I couldn't get the template bit to work, but this could be to do with the versions of the software."
Thanks again
Sue
I've just found this thread, and would like to say it has solved a problem in 10mins that I thought would take me all day to sort out, so many thanks to whoever wrote the code.
In answer to some of the questions,
"I couldn't get the sample.mdb to work. An error message popped up: "Can't find project or library". What did you do to fix this problem? I'm unable to get this to work."
Make sure you have the powerpoint library selected in your references.
In the code window click tools / references (the code must not be running foe this to be available) and see if you have a reference marked as missing.
If so deselect this (it is probably for a diffferent version) and scroll down the list until you see the microsoft powerpoint dll and select this one.
I't worked for me then.
I used the code by just passing it the name of my report, without any template or slide number and it worked fine, multiple pages in my report came out as multiple slides just as I wanted.
Without giving the report a name it just opened powerpoint as a new presentation for each report I exported, so I could save or move slides around as I wanted.
I couldn't get the template bit to work, but this could be to do with the versions of the software."
Thanks again
Sue
Similar threads
