RE: [sqr-users] SQR to Excel - error in opening the output file.

[Bob Stone <bstone@fastenal.com>]

That means the excel file was not closed off correctly, and it expects to
find whatever EOF character(s) at the end...

Check your logic on closing the file.  (different than just open/write/close
sometimes...depending on how complicated your excel printing is).



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Raghvendra Dharwada
Sent: Friday, June 24, 2005 3:37 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR to Excel - error in opening the output file.


Hi,

I have a custom sqc (MM_EXCEL.sqc) which has several functions for 
outputting data from SQR to excel. I am using this SQC in my SQR to print 
the output to excel.The excel file is created successfully and also I get 
the correct output too in the required format.But then, when I try to open 
this excel file I get errors displayed on the Message box saying:

1st Message box:
Cannot read record 7199.
Continue reporting each error?

And when I click 'No' I get the following on the 2nd Message Box:
Microsoft Office Excel cannot convert some of the cells.
The total number of errors found is 1


One of my colleague suggested me to check the cell widths and the numeric 
formats of the cells I am going to print. I verified them too, but still I 
cannot get rid of the error.

Since this is not a general case, I know, it is hard for someone to provide 
a solution, but my hope is that if anyone happened to get similar errors, 
please let me know how you
rectified it.

Thanks.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users