HELP! Charts collection not found - baffled and bewildered pls help

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am transferring an old procedureinto a new application and it works fine
in the old one on the same machine ( a laptop running XP Pro). I simply want
to add a chart programatically with:

Charts.Add

yet in the new one it doesn't appear in the dropdown prompt (i.e. when I
type Charts. Add is not in the choices presented).

When I try to run the code it says 'method or data member not found'.


Any help appreicated, kind regards, Mark
 
Hi Mark
only a guess: Check the references set in the VBA Editor. They should
include a reference to the Excel object library (goto 'Tools -
References' to check this)
 
You must log in or register to reply here.

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 creatting charts with VBA 5
Changing Input to code that creates a chart 2
Creating Charts using VBA 0
Chart Macro?!! Help Please 2
chart.add gives compile error 2
Charts 1
iterate through chart series collection 8
C#: XYScatter chart with smooth lines and no markers 2

Back
Top