Actually no... we've tried, and put it off for awhile. Actually, next week I am supposed to devote my time entirely to figuring out how to fix it. Let me know if you have any insight into it...
I'm working with a rather complex XLA application that
previously had no problems involving EnableEvents when run
in Office 97/2000. In Office XP it does crash however.
Application.EnableEvents is set to False while a
subroutine populates the rows of a sheet with data stored
in memory...
Well the thing is... by specification, I can't put data back onto the spreadsheet to use for the chart. I had some success with the MSChart control, but have since been redirected to creating a PivotTable in VBA and creating a chart from that- only now I can't seem to get the VBA that creates...
I'm trying to create a pie chart in MS Excel 2000 using VB 6. However, I need to do some computations on the data before sending it into the chart, and I can't create new fields on my worksheet to store the results. So my problem is that as far as I can figure out, I can't use...
