hey

i have to write a short VBA script for a school project and i am tryin
to add some charts into my worksheet without success.

i am dealing with an Excel object (which i call App) and i managed t
do everything until i began trying to add charts.
apparently i have a problem in this section
" App.Range("F1,E1,D1,C1,B1,A1").Select
App.Charts.Add
App.ActiveChart.ChartType = xlColumnClustered
... "
i figured the 'xlColumnClustered' is the thing bu
'App.xlColumnClustered' failed also (as well as other chart types).

does anyone have a clue ?

ome

--
Message posted from http://www.ExcelForum.com

Omer -

How did your recorded macro look? What did you do to make it stop working?

Here are some Excel-VBA charting hints.

http://peltiertech.com/Excel/ChartsH...kChartVBA.html

Don't forget to reference your sources.

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

rdoliveo < wrote:

> hey
>
> i have to write a short VBA script for a school project and i am trying
> to add some charts into my worksheet without success.
>
> i am dealing with an Excel object (which i call App) and i managed to
> do everything until i began trying to add charts.
> apparently i have a problem in this section
> " App.Range("F1,E1,D1,C1,B1,A1").Select
> App.Charts.Add
> App.ActiveChart.ChartType = xlColumnClustered
> ... "
> i figured the 'xlColumnClustered' is the thing but
> 'App.xlColumnClustered' failed also (as well as other chart types).
>
> does anyone have a clue ?
>
> omer
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

hey jon , thanks for answering

basically the script works just fine if i run it as an excel macro (
stopped it with the stop recording button) . the problem begins when
am trying do the same thing from a vba script . i took the recorde
macro and after using the getObject method to get a running Exce
application (which i called App), i added the object name before eac
command.

i am having a problem with the following line :

App.ActiveChart.ChartType = xlColumnClustered

and i am not sure which syntax is the right one :
xlColumnClustered \ App.xlColumnClustered\ else ?

ome

--
Message posted from http://www.ExcelForum.com

Omer -

In the other application, have you set a reference the the MS Excel
object model? If not, it has no idea what any of the Excel constants
mean (xlColumnClustered, for instance). You either need to set a
reference (Tools menu > References in the VB Editor), or find out what
long integer xlColumnClustered stands for. In Excel's VB Editor, open
the Immediate window, type a question mark, then the name of the
constant, and press Enter:

?xlColumnClustered
51

Assuming App is the name of the Excel Application object variable, this
line should work:

App.ActiveChart.ChartType = 51

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

rdoliveo < wrote:

> hey jon , thanks for answering
>
> basically the script works just fine if i run it as an excel macro (i
> stopped it with the stop recording button) . the problem begins when i
> am trying do the same thing from a vba script . i took the recorded
> macro and after using the getObject method to get a running Excel
> application (which i called App), i added the object name before each
> command.
>
> i am having a problem with the following line :
>
> App.ActiveChart.ChartType = xlColumnClustered
>
> and i am not sure which syntax is the right one :
> xlColumnClustered \ App.xlColumnClustered\ else ?
>
> omer
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

hey jon
that solved the problem . since i am working with a very limited edito
, i had no way of using early binding .
now that i have realized that late binding forces one to know th
numeric value of constants , took your advice how to learn the value
and made an include file with all the constants.

thanks alot
omer :

--
Message posted from http://www.ExcelForum.com

Glad to help.

- Jon

rdoliveo < wrote:

> hey jon
> that solved the problem . since i am working with a very limited editor
> , i had no way of using early binding .
> now that i have realized that late binding forces one to know the
> numeric value of constants , took your advice how to learn the values
> and made an include file with all the constants.
>
> thanks alot
> omer
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>