Bob Newsome
New Member
I just spend a few hours attempting to find out why my chart creation code would work perfectly on my dev system but when run on another system it would bomb out. It turns out I had set a default chart type in my Excel to a template I had created months earlier. This template had several changes to the default chartType of 51. The first problem that I overcame was the fact that my template had been set with seven series so when I developed my code I had a series waiting and several I had to delete but when I ran the code on another system there was no series waiting and boom, code halt. Having figured out a way around all this I have things working but I would like to know if there is a way to "reset" a chart type instantiated in code to Excel defaults in case my code is run on yet another system with a default template that will have unknown settings.
I hope I've made my question clear. Thanks.
I hope I've made my question clear. Thanks.