Create Pie Chart in Word XP from SQL Query using VBA

[barleywine]

I need to be able to create a series of pie charts in a Word document, using an SQL query as the source of the chart data, and automated using VBA. Any ideas please?

 

[wwgmr]

Dear Barleywine,

I am not sure how to do this my self but what I might suggest is looking at the page below. It goes over Charting data from SQL and using VB 6. I hope it is helpful to you.

http://www.databasejournal.com/features/mssql/article.php/1460281

This article goes into steps with VB 6, its not made for Word or VBA. I hope it maybe can give you some clues though or further information.

Best of luck

Eric

 

[barleywine]

Many thanks Eric - I will give this a go!

Barleywine