View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Problem when trying to set axis properties of a chart by VBA

If you set a reference to excel in your project (Tools|References), then you'll
be able to use all the excel vba's constants.

But I think you're doing better by not using this reference. You're using late
binding and lots of times, this will avoid problems when recipients have
different versions of office.

Sönke Schreiber wrote:

Hello,

The Problem has been solved. If creating Excel object from Word it is not
allowed to use Excel constants. Instead it is necessary to replace e.g.
xlValue by the actual value 2. After eliminating the Excel constants the axes
were displayed correctly.

Kind regards,
Sönke Schreiber


--

Dave Peterson