Interesting issue today with Excel 2007 and a little bit of VBA.
Have a client with issues with an excel addin not interacting well with the bloomberg addin.
So to get around this we used the old toolbar in the addins option.
Problem is that Excel 2007 deselects the Chart, so the active Chart code doesn't work.
This issue doesn't occur in Excel 2010 or Excel 2003.
We were first getting this ambiguous message:
"The specified dimension is not valid for the current chart type"
Another reason to go straight to Excel 2010 to crunch your data and charts.
Regards,
Tom Bizannes
Excel and Database Magician
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment