How can I automate sending a query to excel to chart

[Pack10]

I have a query that I want to send to Excel to chart and display the chart in Access. Is there some sample code
I can leverage, Thanks much.

 

[xlbo]

All depends on your exact situation - you are basically looking for 3 pieces of code

1: Send results of a query to excel
2: Create a chart from that data
3: Display it back in Access

Certainly for 1 & 2 there have been multiple threads around these types of issues which you should be able to leverage. Once you've got those 2 working, we can move onto 3....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Is there any reason you cannot query & chart in MS Access, sans Excel?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}