Problem with Excel98/Chart/Formula

  • Thread starter Thread starter Tobias Schittkowski
  • Start date Start date
T

Tobias Schittkowski

Hi!

I have an application written in VB 6.0 in which I am creating an Excel Chart.
The code below works fine with Excel 2003, but it fails on Excel 97.

Set xlsSeries = ActiveChart.SeriesCollection.NewSeries
xlsSeries.Formula = sFormula

Any Ideas?
Tobias
 
Tobias -

That piece of code hasn't changed since Excel 97. What does sFormula contain?

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