Problem with Excel98/Chart/Formula

  • Thread starter Tobias Schittkowski
  • 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
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Excel97/Chart/Formula 1
Changing ChartTypes will not change the color of the Series 2
esudden extreme slowdown of charting 2
Copy Charts/formulas will not adjust? 0
Problems with XY-Scatter 2
Problem with chart saved in excel 2007 and printed in 2003 2
Can not get Excel macros to save chart format -lost in space! 5
Excel 2007 - Chart not working 1

Top