I am working with a workbook developed by a client in Excel 2003 that has a fair sized block of VBA behind it.
It has worked really well up until my company made the move to Office 2010, now the old workbook throws up errors for nearly everything we do.
I'm not sure what errors lay beyond this one, but it's a good start. I have spent 2 days trying to figure this out, I'm still not even close to a solution.
For a change in one of the spreadsheets, some charts are updated. I have tested this with just a simple chart, and it works there, but when I use it in the old spreadsheet, all I see is
The line of problems:
"Grading Curves" is an XY Scatter chart on it's own sheet.
SeriesName is Text and matches SeriesCollection(1).Name
CalcsColumn is an integer, in this case = 2
XPoints is an integer, in this case = 110
New/Old operating system: XP SP3
Is there anything in anyone's experience that would cause this?
I understand this is a limited amount of code to go by, but being client IP, I can't exactly go flashing it all over the net. Not to mention it's 27 A3 pages double side long
. I could try and get a bit more context if it's required, but I'm hoping that someone has seen this before.
It has worked really well up until my company made the move to Office 2010, now the old workbook throws up errors for nearly everything we do.
I'm not sure what errors lay beyond this one, but it's a good start. I have spent 2 days trying to figure this out, I'm still not even close to a solution.
For a change in one of the spreadsheets, some charts are updated. I have tested this with just a simple chart, and it works there, but when I use it in the old spreadsheet, all I see is
Code:
Run-time error '-2147352571 (80020005)':
The specified dimension is not valid for the current chart type.The line of problems:
Code:
Charts("Grading Curves").SeriesCollection(SeriesName).Values = "=Calcs!R5C" & CalcsColumn & ":R" & XPoints & "C" & CalcsColumn"Grading Curves" is an XY Scatter chart on it's own sheet.
SeriesName is Text and matches SeriesCollection(1).Name
CalcsColumn is an integer, in this case = 2
XPoints is an integer, in this case = 110
New/Old operating system: XP SP3
Is there anything in anyone's experience that would cause this?
I understand this is a limited amount of code to go by, but being client IP, I can't exactly go flashing it all over the net. Not to mention it's 27 A3 pages double side long
. I could try and get a bit more context if it's required, but I'm hoping that someone has seen this before.
