View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default VBA macro creating charts

In my limited experience in charting/modifying charts in VBA under 2007,
that's exactly what it means.

And unless a recent change has been made to 2007, you can't even record a
macro while creating/working with a chart to help you 'cheat' in learning the
new objects and syntax required.

Indeed the look of charts, color schemes, etc are going to be different in
2007. And performance is greatly impacted in 2007 over what you're used to
seeing in 2003 or 2000 charting/graphing efforts.

Probably the easiest way to deal with this is to take your original work and
import into 2007 and save as native 2007 file and break your chart related
code down into pretty fine statements and see where 2007 breaks and focus on
fixing the individual areas that show incompatibility.

"Roland" wrote:

regarding Excel 2007
I have a huge VBA macro, programmed for Excel 2000, which creates charts
from a few sets of data. Some commands (e.g. errorbars) does not match with
Excel 2000 and gives errors. Beside this, the layout of the charts look
totally different with the ones constructed with Excel 2000.
Does this mean I have to review the macro to match for Excel 2007 commands ?