Excel corrupted files solution!!! (at least works for me)

08-04-2003, 12:00 AM
Originally Posted By: Scott A. Keen<scott@scottkeen.com>

I've been having an ongoing problem with AR 2.0 when it comes to creating
Excel files with anything larger than, say, 1000 rows. I know other people
here have been having the same problem.

I get corrupted Excel files which won't open, or they produce error dialog
boxes.

I found that the problem is with the default setting of the Version
property. By default, Version is set to:

objExcel.Version = 8

But if I set the Version to:

objExcel.Version = 5

...for Excel 95/5.0 version compatibility, I don't get corrupted Excel files
any more. Well, at least so far. But, this creates other problems, namely,
when the user opens the file and makes some changes and then saves the file,
they are prompted with a dialog box that says this spreadsheet was created
by an older version of Excel.

It's not a long term solution, and it may not work for you, but it's at
least worth a try! Try setting the Excel export filter version property to
5.

Let us know here if this solves your problem. You can send a consulting fee
to my PayPal account if it fixes the problem for you... :-)

Cheers,

Scott
PARADISE SOFTWARE


Re: Excel corrupted files solution!!! (at least works for me)

08-05-2003, 12:00 AM
Originally Posted By: Eric Johnson - Data Dynamics<eric@datadynamics.com>

Scott,
This issue has been fixed and should be in the next Hot Fix release.

Eric Johnson
Data Dynamics
"Scott A. Keen" wrote in message
news:uoy3SivWDHA.1552@dynaweb.datadynamics.com...
> I've been having an ongoing problem with AR 2.0 when it comes to creating
> Excel files with anything larger than, say, 1000 rows. I know other people
> here have been having the same problem.
>
> I get corrupted Excel files which won't open, or they produce error dialog
> boxes.
>
> I found that the problem is with the default setting of the Version
> property. By default, Version is set to:
>
> objExcel.Version = 8
>
> But if I set the Version to:
>
> objExcel.Version = 5
>
> ...for Excel 95/5.0 version compatibility, I don't get corrupted Excel
files
> any more. Well, at least so far. But, this creates other problems, namely,
> when the user opens the file and makes some changes and then saves the
file,
> they are prompted with a dialog box that says this spreadsheet was created
> by an older version of Excel.
>
> It's not a long term solution, and it may not work for you, but it's at
> least worth a try! Try setting the Excel export filter version property to
> 5.
>
> Let us know here if this solves your problem. You can send a consulting
fee
> to my PayPal account if it fixes the problem for you... :-)
>
> Cheers,
>
> Scott
> PARADISE SOFTWARE
>
>


Re: Excel corrupted files solution!!! (at least works for me)

09-04-2003, 12:00 AM
Originally Posted By: Chris Tull<ctull@covcon.com>

What is the ETA on this Hot Fix??? My clients are not happy with the Excel
export.


"Eric Johnson - Data Dynamics" wrote in message
news:Pvjmdo2WDHA.376@dynaweb.datadynamics.com...
> Scott,
> This issue has been fixed and should be in the next Hot Fix release.
>
> Eric Johnson
> Data Dynamics
> "Scott A. Keen" wrote in message
> news:uoy3SivWDHA.1552@dynaweb.datadynamics.com...
> > I've been having an ongoing problem with AR 2.0 when it comes to
creating
> > Excel files with anything larger than, say, 1000 rows. I know other
people
> > here have been having the same problem.
> >
> > I get corrupted Excel files which won't open, or they produce error
dialog
> > boxes.
> >
> > I found that the problem is with the default setting of the Version
> > property. By default, Version is set to:
> >
> > objExcel.Version = 8
> >
> > But if I set the Version to:
> >
> > objExcel.Version = 5
> >
> > ...for Excel 95/5.0 version compatibility, I don't get corrupted Excel
> files
> > any more. Well, at least so far. But, this creates other problems,
namely,
> > when the user opens the file and makes some changes and then saves the
> file,
> > they are prompted with a dialog box that says this spreadsheet was
created
> > by an older version of Excel.
> >
> > It's not a long term solution, and it may not work for you, but it's at
> > least worth a try! Try setting the Excel export filter version property
to
> > 5.
> >
> > Let us know here if this solves your problem. You can send a consulting
> fee
> > to my PayPal account if it fixes the problem for you... :-)
> >
> > Cheers,
> >
> > Scott
> > PARADISE SOFTWARE
> >
> >
>
>