Board index » delphi » Excel 97 vs Excel 2000

SoftSupport GmbH, Karlsruhe

Delphi Developer
Sat, 04 Jan 2003 03:00:00 GMT

Excel 97 vs Excel 2000

the following peace of code (just one line ;-) ) works fine under NT 4,
Delphi 5 and Excel 97, but not under NT4, Delphi5 and Excel 2000,

I've also tried the updated 2K-Components from the Delphi 5.01 update, it
results in the same error  -->  'OLE-Fehler 800A03EC'

ExcelApplication1.Range['A1','A1'].Value := 10:

What's wrong ?

bye
Stephan Hartmann

 
Reiner Schla

Delphi Developer
Sat, 04 Jan 2003 03:00:00 GMT

Re:Excel 97 vs Excel 2000


SoftSupport GmbH, Karlsruhe schrieb:

Quote
> .....
> ExcelApplication1.Range['A1','A1'].Value := 10:

> What's wrong ?

> bye
> Stephan Hartmann

Hi Stephan,

try

ExcelApplication1.Range['A1:A1','A1:A1'].Value := 10;

Regards Reiner

Oliver Preste

Delphi Developer
Sun, 05 Jan 2003 03:00:00 GMT

Re:Excel 97 vs Excel 2000


Hi Stephan,

you can try:

ExcelApplication1.Cells[1, 1].Value:= 10;
//            RowCount -^  ^- ColCount

Bye,

Oliver

"SoftSupport GmbH, Karlsruhe" schrieb:

Quote
> the following peace of code (just one line ;-) ) works fine under NT 4,
> Delphi 5 and Excel 97, but not under NT4, Delphi5 and Excel 2000,

> I've also tried the updated 2K-Components from the Delphi 5.01 update, it
> results in the same error  -->  'OLE-Fehler 800A03EC'

> ExcelApplication1.Range['A1','A1'].Value := 10:

> What's wrong ?

> bye
> Stephan Hartmann

Oliver Preste

Delphi Developer
Sun, 05 Jan 2003 03:00:00 GMT

Re:Excel 97 vs Excel 2000


Hi Stephan,

you can try:

ExcelApplication1.Cells[1, 1].Value:= 10;
//            RowCount -^  ^- ColCount

Bye,

Oliver

"SoftSupport GmbH, Karlsruhe" schrieb:

Quote
> the following peace of code (just one line ;-) ) works fine under NT 4,
> Delphi 5 and Excel 97, but not under NT4, Delphi5 and Excel 2000,

> I've also tried the updated 2K-Components from the Delphi 5.01 update, it
> results in the same error  -->  'OLE-Fehler 800A03EC'

> ExcelApplication1.Range['A1','A1'].Value := 10:

> What's wrong ?

> bye
> Stephan Hartmann

SoftSupport GmbH, Karlsruh

Delphi Developer
Sun, 05 Jan 2003 03:00:00 GMT

Re:Excel 97 vs Excel 2000


same result -->  'OLE-Fehler 800A03EC'

Reiner Schlay <LC...@t-online.de> schrieb in im Newsbeitrag:
3974793A.4DDF8...@t-online.de...

Quote
> SoftSupport GmbH, Karlsruhe schrieb:
> > .....
> > ExcelApplication1.Range['A1','A1'].Value := 10:

> > What's wrong ?

> > bye
> > Stephan Hartmann

> Hi Stephan,

> try

> ExcelApplication1.Range['A1:A1','A1:A1'].Value := 10;

> Regards Reiner

Reiner Schla

Delphi Developer
Sun, 05 Jan 2003 03:00:00 GMT

Re:Excel 97 vs Excel 2000


Hi stephan,

have a look for
ExcelApplication1.Cells.Items in the VB-Help

i Guess
 ExcelAppLication.Cells.Item[2,2].Value:=10

best regards Reiner

SoftSupport GmbH, Karlsruhe schrieb:

Quote

> same result -->  'OLE-Fehler 800A03EC'

> Reiner Schlay <LC...@t-online.de> schrieb in im Newsbeitrag:
> 3974793A.4DDF8...@t-online.de...
> > SoftSupport GmbH, Karlsruhe schrieb:
> > > .....
> > > ExcelApplication1.Range['A1','A1'].Value := 10:

> > > What's wrong ?

> > > bye
> > > Stephan Hartmann

> > Hi Stephan,

> > try

> > ExcelApplication1.Range['A1:A1','A1:A1'].Value := 10;

> > Regards Reiner

Other Threads

1. Excel 97 <-> Excel 2000

2. Excel 95 vs. Excel 97 with Delphi

3. Excel 97-2000 Macro

4. HOWTO: differentiate between EXCELL 97 and EXCEL 2000

5. Work with Excel 97 AND 2000??

6. Automate both Excel 97 and 2000

7. Excel 97/2000 Workbook PrintPreview

8. Export QRDBReports to Word/Excel 97/2000

9. Excel Problem with Excel '97

10. Code works for Excel 2000 but not Excel XP