| Author | Topic: Excel Chart object and Office 2007 |
|---|
 | Pintr Balzs | Excel Chart object and Office 2007
on Mon, 01 Feb 2010 18:06:50 +0100Hello !
Attached there is a small program creating excel chart.
It works perfectly using Office 2003, but quits generating
error log under Office 2007.
Can anybody help me, what is the difference between the two
Office versions. In the Visual Basic reference there is the same
syntax.
Thank You in advance
Balazs Pinter
The error log:
Xbase++ version : Xbase++ (R) Version 1.90.331
Operating system : Windows Vista 06.01 Build 07600
------------------------------------------------------------------------------
oError:args :
-> VALTYPE: C VALUE: ChartObjects
oError:canDefault : Y
oError:canRetry : N
oError:canSubstitute: Y
oError:cargo : NIL
oError:description :Object has no member with this name
oError:filename : NIL
oError:genCode : NIL
oError:operation : ChartObjects
oError:osCode : -2147352573
oError:severity : 2
oError:subCode : 6500
oError:subSystem : Automation
oError:thread : 1
oError:tries : NIL
------------------------------------------------------------------------------
CALLSTACK:
------------------------------------------------------------------------------
Called from MAIN(30)
 EXCEL07.PRG ATT00006.txt |
| Pintr Balzs | Re: Excel Chart object and Office 2007
on Mon, 01 Feb 2010 18:10:14 +0100I renamed the attached file to txt.
"Pintr Balzs" <recias@mail.datanet.hu> az albbiakat rta a kvetkez
hrzenetben: 3aebb76a$3db9b4a0$62861@news.alaska-software.com...
> Hello !
>
> Attached there is a small program creating excel chart.
> It works perfectly using Office 2003, but quits generating
> error log under Office 2007.
> Can anybody help me, what is the difference between the two
> Office versions. In the Visual Basic reference there is the same
> syntax.
>
> Thank You in advance
>
> Balazs Pinter
>
> The error log:
> Xbase++ version : Xbase++ (R) Version 1.90.331
> Operating system : Windows Vista 06.01 Build 07600
> ------------------------------------------------------------------------------
> oError:args :
> -> VALTYPE: C VALUE: ChartObjects
> oError:canDefault : Y
> oError:canRetry : N
> oError:canSubstitute: Y
> oError:cargo : NIL
> oError:description :Object has no member with this name
> oError:filename : NIL
> oError:genCode : NIL
> oError:operation : ChartObjects
> oError:osCode : -2147352573
> oError:severity : 2
> oError:subCode : 6500
> oError:subSystem : Automation
> oError:thread : 1
> oError:tries : NIL
> ------------------------------------------------------------------------------
> CALLSTACK:
> ------------------------------------------------------------------------------
>
> Called from MAIN(30)
>
>
>
>
>
>
EXCEL07.txt ATT00029.txt |
| Jack Duijf | Re: Excel Chart object and Office 2007
on Tue, 02 Feb 2010 00:43:34 +0100Hello,
The MSDN says:
Worksheet.ChartObjects Method
Notice the METHOD,
So change
oGraph:=oSheet:ChartObjects:Add(0,0,500,300)
to
oGraph:=oSheet:ChartObjects():Add(0,0,500,300)
All works ok now on Office 2007
Regards,
Jack Duijf
Op 1-2-2010 18:06, Pintér Balázs schreef:
> Hello !
>
> Attached there is a small program creating excel chart.
> It works perfectly using Office 2003, but quits generating
> error log under Office 2007.
> Can anybody help me, what is the difference between the two
> Office versions. In the Visual Basic reference there is the same
> syntax.
>
> Thank You in advance
>
> Balazs Pinter
>
> The error log:
> Xbase++ version : Xbase++ (R) Version 1.90.331
> Operating system : Windows Vista 06.01 Build 07600
> ------------------------------------------------------------------------------
> oError:args :
> -> VALTYPE: C VALUE: ChartObjects
> oError:canDefault : Y
> oError:canRetry : N
> oError:canSubstitute: Y
> oError:cargo : NIL
> oError:description :Object has no member with this name
> oError:filename : NIL
> oError:genCode : NIL
> oError:operation : ChartObjects
> oError:osCode : -2147352573
> oError:severity : 2
> oError:subCode : 6500
> oError:subSystem : Automation
> oError:thread : 1
> oError:tries : NIL
> ------------------------------------------------------------------------------
> CALLSTACK:
> ------------------------------------------------------------------------------
>
> Called from MAIN(30)
>
>
>
>
> |
| Pintr Balzs | Re: Excel Chart object and Office 2007
on Tue, 02 Feb 2010 08:06:03 +0100Thank You for Your quick answer.
It works perfectly now.
Best regards
Balazs Pinter
"Jack Duijf" <jack@jdsoftware.nl> az albbiakat rta a kvetkezo
hrzenetben: 6c9c315$159b4094$625af@news.alaska-software.com...
> Hello,
>
> The MSDN says:
> Worksheet.ChartObjects Method
> Notice the METHOD,
>
> So change
> oGraph:=oSheet:ChartObjects:Add(0,0,500,300)
> to
> oGraph:=oSheet:ChartObjects():Add(0,0,500,300)
>
> All works ok now on Office 2007
>
> Regards,
> Jack Duijf
>
>
>
> Op 1-2-2010 18:06, Pintr Balzs schreef:
>> Hello !
>>
>> Attached there is a small program creating excel chart.
>> It works perfectly using Office 2003, but quits generating
>> error log under Office 2007.
>> Can anybody help me, what is the difference between the two
>> Office versions. In the Visual Basic reference there is the same
>> syntax.
>>
>> Thank You in advance
>>
>> Balazs Pinter
>>
>> The error log:
>> Xbase++ version : Xbase++ (R) Version 1.90.331
>> Operating system : Windows Vista 06.01 Build 07600
>> ------------------------------------------------------------------------------
>> oError:args :
>> -> VALTYPE: C VALUE: ChartObjects
>> oError:canDefault : Y
>> oError:canRetry : N
>> oError:canSubstitute: Y
>> oError:cargo : NIL
>> oError:description :Object has no member with this name
>> oError:filename : NIL
>> oError:genCode : NIL
>> oError:operation : ChartObjects
>> oError:osCode : -2147352573
>> oError:severity : 2
>> oError:subCode : 6500
>> oError:subSystem : Automation
>> oError:thread : 1
>> oError:tries : NIL
>> ------------------------------------------------------------------------------
>> CALLSTACK:
>> ------------------------------------------------------------------------------
>>
>> Called from MAIN(30)
>>
>>
>>
>>
>>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4826 (20100202) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4826 (20100202) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com |
| Osvaldo L Aoki | Re: Excel Chart object and Office 2007
on Fri, 15 Oct 2010 15:04:12 -0300HI Jack,
Do you have any documentation about chart object methods ?
For exemple, to show another type of graphics (Pie, 3d bar, line...)
Thanks,
Osvaldo
"Jack Duijf" escreveu na notícia da
mensagem:6c9c315$159b4094$625af@news.alaska-software.com...
Hello,
The MSDN says:
Worksheet.ChartObjects Method
Notice the METHOD,
So change
oGraph:=oSheet:ChartObjects:Add(0,0,500,300)
to
oGraph:=oSheet:ChartObjects():Add(0,0,500,300)
All works ok now on Office 2007
Regards,
Jack Duijf
Op 1-2-2010 18:06, Pintér Balázs schreef:
> Hello !
>
> Attached there is a small program creating excel chart.
> It works perfectly using Office 2003, but quits generating
> error log under Office 2007.
> Can anybody help me, what is the difference between the two
> Office versions. In the Visual Basic reference there is the same
> syntax.
>
> Thank You in advance
>
> Balazs Pinter
>
> The error log:
> Xbase++ version : Xbase++ (R) Version 1.90.331
> Operating system : Windows Vista 06.01 Build 07600
> ------------------------------------------------------------------------------
> oError:args :
> -> VALTYPE: C VALUE: ChartObjects
> oError:canDefault : Y
> oError:canRetry : N
> oError:canSubstitute: Y
> oError:cargo : NIL
> oError:description :Object has no member with this name
> oError:filename : NIL
> oError:genCode : NIL
> oError:operation : ChartObjects
> oError:osCode : -2147352573
> oError:severity : 2
> oError:subCode : 6500
> oError:subSystem : Automation
> oError:thread : 1
> oError:tries : NIL
> ------------------------------------------------------------------------------
> CALLSTACK:
> ------------------------------------------------------------------------------
>
> Called from MAIN(30)
>
>
>
>
> |
