Create Access VBA Graphics & copy to Word/Powepoint

[VBApprentice :)]

Dear All,
An interesting problem, I thought some of the MVPs/Gurus/Masters may have
some experience and provide some help/guidance if possible please.
80,000+ records in a table, need to generate XY graphs of this data
automatically first and then paste the graphs in a DOC and PPT.
I tried the ActiveX it helps in generating the graphs but doesnt allow to
put the graph in PPT or DOC.
If you could help in solving this interesting problem, I appreciate your
help very much.
Best regards to all of the MVPs/Gurus/Masters and novices like myself

 

[Robert Morley]

Hahaha...just clued in to what the name was changed from. Very nice.

I don't have any "nice" suggestions for you in regards to your problem, but
a "not so nice" way of handling it, provided you can view the graphs
on-screen (which it sounds like you can) is to just do a screen-capture
by-hand and cut & paste it into your PowerPoint or Word document. There's a
utility called SnagIt that can be very useful for captures of this nature,
as it can usually capture just the form, and often even just the control
that you're trying to capture.

Not a great way, but it gets you there after a fashion.



Rob