I am using Office 2000 and have developed a word application using MS Word and VB Script to create customized reports (about 1,800 reports). The 6 graphs in the report are charted using data from MS Access. After about 400-500 iteration the MS Chart control konks out. It has nothing to do with the data becasue if I close word and reopen it and begin at the iteration where it left then everything works. The time to konk out seems to be random but occurs anywhere between 400-500 iteration increments.
Any idea of what is going on? Is their anyway in vb script to kill the msgraph.exe application and refresh it rather then having to close word?
Also, what is the best chart control on the market that is an alternative to the mschart conrol?