Access 97 Chart Export to Powerpoint

[ewong1]

Is there a way for me to export my report/Chart to a powerpoint document? I have seen other articles on the forum but they only refer to later version of access. I am running access 97.

 

[richary]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;177270

 

[ewong1]

You are awesome! That helps so much! I just have one more question. Is there any way for the graph to include a "goal" line? Currently with the vb that you showed me, I am only able to set up a set of bar graphs. Any ideas would be greatly appreciated. Thanks for your help!

 

[richary]

Horizontal or vertical goal line?

 

[ewong1]

horizontal goal line

 

[ewong1]

One thing that I am also running into when I export the data to a power point presentation is that I am getting the error message "Object doesn't support this property or method." Any ideas on what may be causing this? I used the code generated from the link associated with Microsoft on this thread.

 

[richary]

What line is the debugger complaining about?

I've had a look at adding the goal line. I'm basically trying to follow the method outlined in

http://www.peltiertech.com/Excel/Charts/AddLineHorzSeries.html

but am having trouble with the MSGraph object model in that I can't find the right .ChartType.

One thought is that you could set up a standard graph and ppt slide combination and then modify the code to alter the data to fit your info. An extra series is needed for the goal line so you'll need to alter the original code
below

lRowCnt = lRowCnt + 1
CGFF_Rs.MoveNext
Loop


' Update the graph.

....to something like....

lRowCnt = lRowCnt + 1
CGFF_Rs.MoveNext
Loop

For i = 2 To lRowCnt

oDataSheet.Cells(CGFF_FldCnt, i) = YourGoalLIneVariable
Next i

' Update the graph.

where "YourGoalLineVariable" is an extra parameter passed to CreateGraphFromFile()

I'd give you a hand with the coding, but I'm on a half day today and then off on holiday until late next week.

Good luck!

 

[ewong1]

When I get the error, the debugger does not specify a line of code that is related to the error. What I am running into is this:

Access exports the data into power point and then gives me the error message. I am able to click ok to eliminate the error message and open the power point file to see what the exported data looks like and it works fine. The reason I would like to get rid of the error is because I wanted to export multiple charts at one time. It is a problem now because the error stops the program sequence entirely. Let me know if you have any ideas. Thanks!

 

[richary]

Hi
Try stepping through the code one line at a time, using the F8 key.
I've just tried it on my system (Acc2000) and it works fine. I don't have a machine with Acc97 on to hand, but I can try it at home this evening.