D5 and Excel XP (Excel 2002) problems

S?re

Delphi Developer

Fri, 08 Oct 2004 17:39:11 GMT

D5 and Excel XP (Excel 2002) problems

Im trying to create a oleautomation application in Delphi5, using Excel
2002. I want to create a document based on a excel template and then fill
some data into it.

When I do the following:
ExcelApplication.Workbooks.Add (EmptyParam, 1);

I get a errormessage saying: "Old format or invalid type library".

Does anybody know how to solve this (any codeexamples would be very nice).

Best regards
Soren

S?re

Delphi Developer

Fri, 08 Oct 2004 17:46:34 GMT

Re:D5 and Excel XP (Excel 2002) problems

Correction, it is when I try to do the following:

ExcelApplication.Workbooks.Open (Filename, EmptyParam, EmptyParam,
EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam, 1);

Cheers!

Quote

"S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message

news:3cc3d9ce_1@dnews...

Quote

> Hi

> Im trying to create a oleautomation application in Delphi5, using Excel
> 2002. I want to create a document based on a excel template and then fill
> some data into it.

> When I do the following:
> ExcelApplication.Workbooks.Add (EmptyParam, 1);

> I get a errormessage saying: "Old format or invalid type library".

> Does anybody know how to solve this (any codeexamples would be very nice).

> Best regards
> Soren

Radu Serbanesc

Delphi Developer

Fri, 08 Oct 2004 17:47:52 GMT

Re:D5 and Excel XP (Excel 2002) problems

look in microsoft.public.excel newsgroup, it's something related to
language settings, easy to correct.

radu

Quote

"S?ren" wrote:

> Hi

> Im trying to create a oleautomation application in Delphi5, using Excel
> 2002. I want to create a document based on a excel template and then fill
> some data into it.

> When I do the following:
> ExcelApplication.Workbooks.Add (EmptyParam, 1);

> I get a errormessage saying: "Old format or invalid type library".

> Does anybody know how to solve this (any codeexamples would be very nice).

> Best regards
> Soren

S?re

Delphi Developer

Fri, 08 Oct 2004 17:58:15 GMT

Re:D5 and Excel XP (Excel 2002) problems

There is no newsgroup called just ....public.excel ! They all have something
after excel. Please guide me a little more.

Thank you

- Soren

Quote

"Radu Serbanescu" <r...@umt.rdsnet.ro> wrote in message

news:3CC3DC48.5AC48EFF@umt.rdsnet.ro...

Quote

> look in microsoft.public.excel newsgroup, it's something related to
> language settings, easy to correct.

> radu

> "S?ren" wrote:

> > Hi

> > Im trying to create a oleautomation application in Delphi5, using Excel
> > 2002. I want to create a document based on a excel template and then
fill
> > some data into it.

> > When I do the following:
> > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > I get a errormessage saying: "Old format or invalid type library".

> > Does anybody know how to solve this (any codeexamples would be very
nice).

> > Best regards
> > Soren

Alain Quesne

Delphi Developer

Fri, 08 Oct 2004 20:14:04 GMT

Re:D5 and Excel XP (Excel 2002) problems

When I do this on my machine, I use 14 "emptyparams". Maybe you need to
re-generate your Excel type library. Was it created with Excel 2002?

Alain Quesnel
cinqsanss...@compuserve.com

Quote

"S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message

news:3cc3db88$1_2@dnews...

Quote

> Correction, it is when I try to do the following:

> ExcelApplication.Workbooks.Open (Filename, EmptyParam, EmptyParam,
> EmptyParam, EmptyParam,
> EmptyParam, EmptyParam, EmptyParam,
> EmptyParam, EmptyParam,
> EmptyParam, EmptyParam, EmptyParam, 1);

> Cheers!

> "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> news:3cc3d9ce_1@dnews...
> > Hi

> > Im trying to create a oleautomation application in Delphi5, using Excel
> > 2002. I want to create a document based on a excel template and then
fill
> > some data into it.

> > When I do the following:
> > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > I get a errormessage saying: "Old format or invalid type library".

> > Does anybody know how to solve this (any codeexamples would be very
nice).

> > Best regards
> > Soren

S?re

Delphi Developer

Fri, 08 Oct 2004 20:18:35 GMT

Re:D5 and Excel XP (Excel 2002) problems

There is no newsgroup called just ....public.excel ! They all have something
after excel. Please guide me a little more.

Thank you

- Soren

Quote

"Radu Serbanescu" <r...@umt.rdsnet.ro> wrote in message

news:3CC3DC48.5AC48EFF@umt.rdsnet.ro...

Quote

> look in microsoft.public.excel newsgroup, it's something related to
> language settings, easy to correct.

> radu

> "S?ren" wrote:

> > Hi

> > Im trying to create a oleautomation application in Delphi5, using Excel
> > 2002. I want to create a document based on a excel template and then
fill
> > some data into it.

> > When I do the following:
> > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > I get a errormessage saying: "Old format or invalid type library".

> > Does anybody know how to solve this (any codeexamples would be very
nice).

> > Best regards
> > Soren

S?re

Delphi Developer

Fri, 08 Oct 2004 20:18:21 GMT

Re:D5 and Excel XP (Excel 2002) problems

?! No I guess not. How do I do that ?

Thank you!

Cheers, Soren

Quote

"Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message

news:3cc3fedb$1_2@dnews...

Quote

> When I do this on my machine, I use 14 "emptyparams". Maybe you need to
> re-generate your Excel type library. Was it created with Excel 2002?

> --

> Alain Quesnel
> cinqsanss...@compuserve.com

> "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> news:3cc3db88$1_2@dnews...
> > Correction, it is when I try to do the following:

> > ExcelApplication.Workbooks.Open (Filename, EmptyParam, EmptyParam,
> > EmptyParam, EmptyParam,
> > EmptyParam, EmptyParam, EmptyParam,
> > EmptyParam, EmptyParam,
> > EmptyParam, EmptyParam, EmptyParam, 1);

> > Cheers!

> > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > news:3cc3d9ce_1@dnews...
> > > Hi

> > > Im trying to create a oleautomation application in Delphi5, using
Excel
> > > 2002. I want to create a document based on a excel template and then
> fill
> > > some data into it.

> > > When I do the following:
> > > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > > I get a errormessage saying: "Old format or invalid type library".

> > > Does anybody know how to solve this (any codeexamples would be very
> nice).

> > > Best regards
> > > Soren

Mike Shkolni

Delphi Developer

Fri, 08 Oct 2004 20:42:59 GMT

Re:D5 and Excel XP (Excel 2002) problems

Soren,

as I remember with Delphi 5 the type library for Excel 97 or 2000 are
available only. Did you import a new type library for your MS Excel 2002?

--
With best regards, Mike Shkolnik
E-Mail: mshkol...@scalabium.com
WEB: http://www.scalabium.com

S?ren <sbbREM...@cadmos.carlbro.be> D??? ???Y??:3cc3d9ce_1@dnews...

Quote

> Hi

> Im trying to create a oleautomation application in Delphi5, using Excel
> 2002. I want to create a document based on a excel template and then fill
> some data into it.

> When I do the following:
> ExcelApplication.Workbooks.Add (EmptyParam, 1);

> I get a errormessage saying: "Old format or invalid type library".

> Does anybody know how to solve this (any codeexamples would be very nice).

> Best regards
> Soren

Alain Quesne

Delphi Developer

Fri, 08 Oct 2004 21:46:39 GMT

Re:D5 and Excel XP (Excel 2002) problems

Go to "Project | Import Type Library", select "Microsoft Excel 10.0 Object
Library", uncheck "Generate Component Wrapper" and click on "Create Unit".
You will have a new file called Excel_TLB.pas in your "C:\Program
Files\Borland\Delphi6\Imports\" directory (by default).

Alain Quesnel
cinqsanss...@compuserve.com

Quote

"S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message

news:3cc3ff1b_2@dnews...

Quote

> ?! No I guess not. How do I do that ?

> Thank you!

> Cheers, Soren

> "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> news:3cc3fedb$1_2@dnews...
> > When I do this on my machine, I use 14 "emptyparams". Maybe you need to
> > re-generate your Excel type library. Was it created with Excel 2002?

> > --

> > Alain Quesnel
> > cinqsanss...@compuserve.com

> > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > news:3cc3db88$1_2@dnews...
> > > Correction, it is when I try to do the following:

> > > ExcelApplication.Workbooks.Open (Filename, EmptyParam, EmptyParam,
> > > EmptyParam, EmptyParam,
> > > EmptyParam, EmptyParam, EmptyParam,
> > > EmptyParam, EmptyParam,
> > > EmptyParam, EmptyParam, EmptyParam,
1);

> > > Cheers!

> > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > news:3cc3d9ce_1@dnews...
> > > > Hi

> > > > Im trying to create a oleautomation application in Delphi5, using
> Excel
> > > > 2002. I want to create a document based on a excel template and then
> > fill
> > > > some data into it.

> > > > When I do the following:
> > > > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > > > I get a errormessage saying: "Old format or invalid type library".

> > > > Does anybody know how to solve this (any codeexamples would be very
> > nice).

> > > > Best regards
> > > > Soren

S?re

Delphi Developer

Fri, 08 Oct 2004 23:25:28 GMT

Re:D5 and Excel XP (Excel 2002) problems

Ok, It was already installed. I guess thats not my problem then!

Additional information.
I have no problem working with outlook 2002 and word 2002 from D5, just
Excel.

I anybody has a codeexample, im very interested (maby my approach is just
wrong).

Cheers, S?ren

Quote

"Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message

news:3cc4148b$1_1@dnews...

Quote

> Go to "Project | Import Type Library", select "Microsoft Excel 10.0 Object
> Library", uncheck "Generate Component Wrapper" and click on "Create Unit".
> You will have a new file called Excel_TLB.pas in your "C:\Program
> Files\Borland\Delphi6\Imports\" directory (by default).

> --

> Alain Quesnel
> cinqsanss...@compuserve.com

> "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> news:3cc3ff1b_2@dnews...
> > ?! No I guess not. How do I do that ?

> > Thank you!

> > Cheers, Soren

> > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > news:3cc3fedb$1_2@dnews...
> > > When I do this on my machine, I use 14 "emptyparams". Maybe you need
to
> > > re-generate your Excel type library. Was it created with Excel 2002?

> > > --

> > > Alain Quesnel
> > > cinqsanss...@compuserve.com

> > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > news:3cc3db88$1_2@dnews...
> > > > Correction, it is when I try to do the following:

> > > > ExcelApplication.Workbooks.Open (Filename, EmptyParam, EmptyParam,
> > > > EmptyParam, EmptyParam,
> > > > EmptyParam, EmptyParam, EmptyParam,
> > > > EmptyParam, EmptyParam,
> > > > EmptyParam, EmptyParam, EmptyParam,
> 1);

> > > > Cheers!

> > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > news:3cc3d9ce_1@dnews...
> > > > > Hi

> > > > > Im trying to create a oleautomation application in Delphi5, using
> > Excel
> > > > > 2002. I want to create a document based on a excel template and
then
> > > fill
> > > > > some data into it.

> > > > > When I do the following:
> > > > > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > > > > I get a errormessage saying: "Old format or invalid type library".

> > > > > Does anybody know how to solve this (any codeexamples would be
very
> > > nice).

> > > > > Best regards
> > > > > Soren

S?re

Delphi Developer

Fri, 08 Oct 2004 23:26:57 GMT

Re:D5 and Excel XP (Excel 2002) problems

I cheked the typelibrary, and I have "Microsoft Excel 10.0 Object Library
(Version 1.4)" installed!

Best regards
Soren

Quote

"Mike Shkolnik" <mshkol...@yahoo.com> wrote in message

news:3cc40501_2@dnews...

Quote

> Soren,

> as I remember with Delphi 5 the type library for Excel 97 or 2000 are
> available only. Did you import a new type library for your MS Excel 2002?

> --
> With best regards, Mike Shkolnik
> E-Mail: mshkol...@scalabium.com
> WEB: http://www.scalabium.com

> S?ren <sbbREM...@cadmos.carlbro.be> D??? ???Y??:3cc3d9ce_1@dnews...
> > Hi

> > Im trying to create a oleautomation application in Delphi5, using Excel
> > 2002. I want to create a document based on a excel template and then
fill
> > some data into it.

> > When I do the following:
> > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > I get a errormessage saying: "Old format or invalid type library".

> > Does anybody know how to solve this (any codeexamples would be very
nice).

> > Best regards
> > Soren

Alain Quesne

Delphi Developer

Fri, 08 Oct 2004 23:55:18 GMT

Re:D5 and Excel XP (Excel 2002) problems

What do you mean by already installed? If it's the original Excel_TLB.pas
file form the Delphi 6 installation, chances are it's not the one from Excel
2002.

Alain Quesnel
cinqsanss...@compuserve.com

Quote

"S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message

news:3cc42af6_2@dnews...

Quote

> Ok, It was already installed. I guess thats not my problem then!

> Additional information.
> I have no problem working with outlook 2002 and word 2002 from D5, just
> Excel.

> I anybody has a codeexample, im very interested (maby my approach is just
> wrong).

> Cheers, S?ren

> "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> news:3cc4148b$1_1@dnews...
> > Go to "Project | Import Type Library", select "Microsoft Excel 10.0
Object
> > Library", uncheck "Generate Component Wrapper" and click on "Create
Unit".
> > You will have a new file called Excel_TLB.pas in your "C:\Program
> > Files\Borland\Delphi6\Imports\" directory (by default).

> > --

> > Alain Quesnel
> > cinqsanss...@compuserve.com

> > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > news:3cc3ff1b_2@dnews...
> > > ?! No I guess not. How do I do that ?

> > > Thank you!

> > > Cheers, Soren

> > > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > > news:3cc3fedb$1_2@dnews...
> > > > When I do this on my machine, I use 14 "emptyparams". Maybe you need
> to
> > > > re-generate your Excel type library. Was it created with Excel 2002?

> > > > --

> > > > Alain Quesnel
> > > > cinqsanss...@compuserve.com

> > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > news:3cc3db88$1_2@dnews...
> > > > > Correction, it is when I try to do the following:

> > > > > ExcelApplication.Workbooks.Open (Filename, EmptyParam, EmptyParam,
> > > > > EmptyParam, EmptyParam,
> > > > > EmptyParam, EmptyParam,
EmptyParam,
> > > > > EmptyParam, EmptyParam,
> > > > > EmptyParam, EmptyParam,
EmptyParam,
> > 1);

> > > > > Cheers!

> > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > news:3cc3d9ce_1@dnews...
> > > > > > Hi

> > > > > > Im trying to create a oleautomation application in Delphi5,
using
> > > Excel
> > > > > > 2002. I want to create a document based on a excel template and
> then
> > > > fill
> > > > > > some data into it.

> > > > > > When I do the following:
> > > > > > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > > > > > I get a errormessage saying: "Old format or invalid type
library".

> > > > > > Does anybody know how to solve this (any codeexamples would be
> very
> > > > nice).

> > > > > > Best regards
> > > > > > Soren

S?re

Delphi Developer

Sat, 09 Oct 2004 01:06:33 GMT

Re:D5 and Excel XP (Excel 2002) problems

Under import type library, when pressing "Create unit" (and unticking
"Generate component wrapper"), I get a errormessage saying "A class named
"TExcelQueryTable" is already installed".

Cheers, S?ren

Quote

"Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message

news:3cc432b2$1_2@dnews...

Quote

> What do you mean by already installed? If it's the original Excel_TLB.pas
> file form the Delphi 6 installation, chances are it's not the one from
Excel
> 2002.

> --

> Alain Quesnel
> cinqsanss...@compuserve.com

> "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> news:3cc42af6_2@dnews...
> > Ok, It was already installed. I guess thats not my problem then!

> > Additional information.
> > I have no problem working with outlook 2002 and word 2002 from D5, just
> > Excel.

> > I anybody has a codeexample, im very interested (maby my approach is
just
> > wrong).

> > Cheers, S?ren

> > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > news:3cc4148b$1_1@dnews...
> > > Go to "Project | Import Type Library", select "Microsoft Excel 10.0
> Object
> > > Library", uncheck "Generate Component Wrapper" and click on "Create
> Unit".
> > > You will have a new file called Excel_TLB.pas in your "C:\Program
> > > Files\Borland\Delphi6\Imports\" directory (by default).

> > > --

> > > Alain Quesnel
> > > cinqsanss...@compuserve.com

> > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > news:3cc3ff1b_2@dnews...
> > > > ?! No I guess not. How do I do that ?

> > > > Thank you!

> > > > Cheers, Soren

> > > > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > > > news:3cc3fedb$1_2@dnews...
> > > > > When I do this on my machine, I use 14 "emptyparams". Maybe you
need
> > to
> > > > > re-generate your Excel type library. Was it created with Excel
2002?

> > > > > --

> > > > > Alain Quesnel
> > > > > cinqsanss...@compuserve.com

> > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > news:3cc3db88$1_2@dnews...
> > > > > > Correction, it is when I try to do the following:

> > > > > > ExcelApplication.Workbooks.Open (Filename, EmptyParam,
EmptyParam,
> > > > > > EmptyParam, EmptyParam,
> > > > > > EmptyParam, EmptyParam,
> EmptyParam,
> > > > > > EmptyParam, EmptyParam,
> > > > > > EmptyParam, EmptyParam,
> EmptyParam,
> > > 1);

> > > > > > Cheers!

> > > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > > news:3cc3d9ce_1@dnews...
> > > > > > > Hi

> > > > > > > Im trying to create a oleautomation application in Delphi5,
> using
> > > > Excel
> > > > > > > 2002. I want to create a document based on a excel template
and
> > then
> > > > > fill
> > > > > > > some data into it.

> > > > > > > When I do the following:
> > > > > > > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > > > > > > I get a errormessage saying: "Old format or invalid type
> library".

> > > > > > > Does anybody know how to solve this (any codeexamples would be
> > very
> > > > > nice).

> > > > > > > Best regards
> > > > > > > Soren

Alain Quesne

Delphi Developer

Sat, 09 Oct 2004 03:50:42 GMT

Re:D5 and Excel XP (Excel 2002) problems

Go to your package list, and uninstall the Office Server components.

Alain Quesnel
cinqsanss...@compuserve.com

Quote

"S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message

news:3cc442a6_1@dnews...

Quote

> Under import type library, when pressing "Create unit" (and unticking
> "Generate component wrapper"), I get a errormessage saying "A class named
> "TExcelQueryTable" is already installed".

> Cheers, S?ren

> "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> news:3cc432b2$1_2@dnews...
> > What do you mean by already installed? If it's the original
Excel_TLB.pas
> > file form the Delphi 6 installation, chances are it's not the one from
> Excel
> > 2002.

> > --

> > Alain Quesnel
> > cinqsanss...@compuserve.com

> > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > news:3cc42af6_2@dnews...
> > > Ok, It was already installed. I guess thats not my problem then!

> > > Additional information.
> > > I have no problem working with outlook 2002 and word 2002 from D5,
just
> > > Excel.

> > > I anybody has a codeexample, im very interested (maby my approach is
> just
> > > wrong).

> > > Cheers, S?ren

> > > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > > news:3cc4148b$1_1@dnews...
> > > > Go to "Project | Import Type Library", select "Microsoft Excel 10.0
> > Object
> > > > Library", uncheck "Generate Component Wrapper" and click on "Create
> > Unit".
> > > > You will have a new file called Excel_TLB.pas in your "C:\Program
> > > > Files\Borland\Delphi6\Imports\" directory (by default).

> > > > --

> > > > Alain Quesnel
> > > > cinqsanss...@compuserve.com

> > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > news:3cc3ff1b_2@dnews...
> > > > > ?! No I guess not. How do I do that ?

> > > > > Thank you!

> > > > > Cheers, Soren

> > > > > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > > > > news:3cc3fedb$1_2@dnews...
> > > > > > When I do this on my machine, I use 14 "emptyparams". Maybe you
> need
> > > to
> > > > > > re-generate your Excel type library. Was it created with Excel
> 2002?

> > > > > > --

> > > > > > Alain Quesnel
> > > > > > cinqsanss...@compuserve.com

> > > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > > news:3cc3db88$1_2@dnews...
> > > > > > > Correction, it is when I try to do the following:

> > > > > > > ExcelApplication.Workbooks.Open (Filename, EmptyParam,
> EmptyParam,
> > > > > > > EmptyParam, EmptyParam,
> > > > > > > EmptyParam, EmptyParam,
> > EmptyParam,
> > > > > > > EmptyParam, EmptyParam,
> > > > > > > EmptyParam, EmptyParam,
> > EmptyParam,
> > > > 1);

> > > > > > > Cheers!

> > > > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > > > news:3cc3d9ce_1@dnews...
> > > > > > > > Hi

> > > > > > > > Im trying to create a oleautomation application in Delphi5,
> > using
> > > > > Excel
> > > > > > > > 2002. I want to create a document based on a excel template
> and
> > > then
> > > > > > fill
> > > > > > > > some data into it.

> > > > > > > > When I do the following:
> > > > > > > > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > > > > > > > I get a errormessage saying: "Old format or invalid type
> > library".

> > > > > > > > Does anybody know how to solve this (any codeexamples would
be
> > > very
> > > > > > nice).

> > > > > > > > Best regards
> > > > > > > > Soren

S?re

Delphi Developer

Sat, 09 Oct 2004 16:21:54 GMT

Re:D5 and Excel XP (Excel 2002) problems

Im a little confused. When I choose "Components | Install packages" there is
nothing called Office Server Components!?

Do I need a special TLB-file that supports Excel 2002 (where do I get that)
or is a re-generate enough (cant seem to find out how to do that :-| )?

Cheers, Soren

Quote

"Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message

news:3cc469dc$2_1@dnews...

Quote

> Go to your package list, and uninstall the Office Server components.

> --

> Alain Quesnel
> cinqsanss...@compuserve.com

> "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> news:3cc442a6_1@dnews...
> > Under import type library, when pressing "Create unit" (and unticking
> > "Generate component wrapper"), I get a errormessage saying "A class
named
> > "TExcelQueryTable" is already installed".

> > Cheers, S?ren

> > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > news:3cc432b2$1_2@dnews...
> > > What do you mean by already installed? If it's the original
> Excel_TLB.pas
> > > file form the Delphi 6 installation, chances are it's not the one from
> > Excel
> > > 2002.

> > > --

> > > Alain Quesnel
> > > cinqsanss...@compuserve.com

> > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > news:3cc42af6_2@dnews...
> > > > Ok, It was already installed. I guess thats not my problem then!

> > > > Additional information.
> > > > I have no problem working with outlook 2002 and word 2002 from D5,
> just
> > > > Excel.

> > > > I anybody has a codeexample, im very interested (maby my approach is
> > just
> > > > wrong).

> > > > Cheers, S?ren

> > > > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > > > news:3cc4148b$1_1@dnews...
> > > > > Go to "Project | Import Type Library", select "Microsoft Excel
10.0
> > > Object
> > > > > Library", uncheck "Generate Component Wrapper" and click on
"Create
> > > Unit".
> > > > > You will have a new file called Excel_TLB.pas in your "C:\Program
> > > > > Files\Borland\Delphi6\Imports\" directory (by default).

> > > > > --

> > > > > Alain Quesnel
> > > > > cinqsanss...@compuserve.com

> > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > news:3cc3ff1b_2@dnews...
> > > > > > ?! No I guess not. How do I do that ?

> > > > > > Thank you!

> > > > > > Cheers, Soren

> > > > > > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > > > > > news:3cc3fedb$1_2@dnews...
> > > > > > > When I do this on my machine, I use 14 "emptyparams". Maybe
you
> > need
> > > > to
> > > > > > > re-generate your Excel type library. Was it created with Excel
> > 2002?

> > > > > > > --

> > > > > > > Alain Quesnel
> > > > > > > cinqsanss...@compuserve.com

> > > > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > > > news:3cc3db88$1_2@dnews...
> > > > > > > > Correction, it is when I try to do the following:

> > > > > > > > ExcelApplication.Workbooks.Open (Filename, EmptyParam,
> > EmptyParam,
> > > > > > > > EmptyParam, EmptyParam,
> > > > > > > > EmptyParam, EmptyParam,
> > > EmptyParam,
> > > > > > > > EmptyParam, EmptyParam,
> > > > > > > > EmptyParam, EmptyParam,
> > > EmptyParam,
> > > > > 1);

> > > > > > > > Cheers!

> > > > > > > > "S?ren" <sbbREM...@cadmos.carlbro.be> wrote in message
> > > > > > > > news:3cc3d9ce_1@dnews...
> > > > > > > > > Hi

> > > > > > > > > Im trying to create a oleautomation application in
Delphi5,
> > > using
> > > > > > Excel
> > > > > > > > > 2002. I want to create a document based on a excel
template
> > and
> > > > then
> > > > > > > fill
> > > > > > > > > some data into it.

> > > > > > > > > When I do the following:
> > > > > > > > > ExcelApplication.Workbooks.Add (EmptyParam, 1);

> > > > > > > > > I get a errormessage saying: "Old format or invalid type
> > > library".

> > > > > > > > > Does anybody know how to solve this (any codeexamples
would
> be
> > > > very
> > > > > > > nice).

> > > > > > > > > Best regards
> > > > > > > > > Soren

Go to page: [1] [2]

Other Threads

1. ShellExecute and Excel XP (2002) problems

2. Solved: Creating an Excel 2002 worksheet from D5

3. Saving an Excel 2002 worksheet from D5

4. D5 and Excel 2002

5. Problems Moving to Excel 2002 and Delphi 6

6. Excel 2002 problem

7. Bug in Delphi 7.0? ADO and Excel 2002

8. Code works for Excel 2000 but not Excel XP

9. D6 -> Word XP/2002

10. Outlook 2000 works But XP(2002) Does not.