Excel 2007: get formula from charttitle
 

I have been using this code to get a formula from a charttitle:

oChart.Activate
sTitle = ExecuteExcel4Macro("GET.FORMULA(""Title"")")

It no longer works in excel 2007. Can someone tell me how to get a
formula from a charttitle using VBA?

Thanks
b

Excel 2007: get formula from charttitle
 

This sounds so familiar. I believe I've reported this as a bug.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
I have been using this code to get a formula from a charttitle:

oChart.Activate
sTitle = ExecuteExcel4Macro("GET.FORMULA(""Title"")")

It no longer works in excel 2007. Can someone tell me how to get a
formula from a charttitle using VBA?

Thanks
b