Thanks Mike,
I'm trying to open an excel file that was saved within excel 2007 in an excel
2003 format. (excention is the default 2003 ".xls".) To trace down this
problem,. i've installed office 2003 onto my pc.
My old code fails at the point when opening and saving to an excel workbook. I
presume the amount of parameters has changed? It did work fine untill these
files
Fails at follwing point:
var
Application: TExcelApplication
FCurrentWorkbook: ExcelWorkbook;
...
FCurrentWorkbook := Application.Workbooks.Open(AFileName, EmptyParam,
EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, 1);
It will present the error message " old format or invalid type... (it's a
dutch message). Googling around, I found
http://support.microsoft.com/kb/320369 but if this is the correct solution? (I
did stick to the dutch version and did not change any regional setting, so i'm
not sure if this will provide me with a solution.
Any ideas on how to check the exel version (<=2003) and where to find the
correct usage of there parameters?
Regards
Andries Bos
The netherlands
----- Original Message ----
From: Mike Shkolnik <[EMAIL PROTECTED]>
To: delphi-en@yahoogroups.com
Sent: Thursday, August 21, 2008 1:12:20 PM
Subject: Re: [delphi-en] excel 2003 versus excel 2007
Just change the file name with new extension (c:\aaa.xlsx) and saved file will
be in new format automatically. No additional changes in code required
With best regards, Mike Shkolnik
EMail: [EMAIL PROTECTED] .com
http://www.scalabiu m.com
--- On Thu, 8/21/08, Andries Bos <[EMAIL PROTECTED] com> wrote:
> From: Andries Bos <[EMAIL PROTECTED] com>
> Subject: [delphi-en] excel 2003 versus excel 2007
> To: "delphi advanced group" <[EMAIL PROTECTED] ps.com>
> Date: Thursday, August 21, 2008, 1:18 PM
> Hello
>
> At this moment we use and import excel
> docuements/spreadsh eets using a TExcelApplication object.
>
> Some users have and want to use Office 2007 (and excel 2007
> format). I've heard that this version saves the data in
> xml format with a new extention.
>
> What do I have to do to be able to support Office 2007
> documents within my Delphi 7 application? Is the only option
> for them to use a 'save as..' and create an older
> format xml file?
>
> Any suggestions will be welcome
>
> Regards
>
> Andries
>
>
[Non-text portions of this message have been removed]
