Does Excel 2011 support .ApplyChartTemplate?

Hi - I've been using a macro with OSX Excel 2004 for years. I just bought 2011.

In the 2004 version I apply a user-defined custom chart. Since user-defined charts seem to have disappeared from post-2004 Excel versions, in 2011 I've tried to apply a Chart Template via VBA.

But this just won't work. I record a macro which applies a Chart Template, like this:

ActiveChart.ApplyChartTemplate ( _
"/Users/jsmith/Library/Application Support/Microsoft/Office/Chart Templates/Investment_Chart.crtx" _
)

But when I play it back, I get the error message: "The specified dimension is not valid for the current chart type". It works ok if I apply the template manually, but VBA chokes on it.

Is the ApplyChartTemplate working in Excel 2011? Or what VBA command would let me get this done? Thanks....

PS. Anyone know how VBA in 2011 compares to recent Windows versions?

Hi

You have the syntax almost right. You need to include the Hard Drive name at the beginning of the file path. Also, the file path separator is the colon (not slash), like this:

Please Login or Register  to view this content.