bb.donnay-software.com

That's what I did.
And end the function with " Return lStatus " so you can test for an early exit.

After much trial and error, if this line: oBook:SaveAs(cExcelFile,xlWorkbookNormal,cPassword) is bypassed after testing lStatus and getting .f., either oBook cannot be closed and destroyed or oExcel cannot be 'quit' or destroyed, can't tell which, and this locks the exe. The 'cancel' button now exit...

Thanks, Roger, this destroys the dialog window.
But Excel is still running (oExcel not destroyed?).
The result is that the exe freezes until Excel is closed with 'task manager'.

Is it also possible to return .f. if lStatus = .f. to allow testing for a cancel?

The cancel button in the progress window for DC_Array2Excel does not terminate the process of building the spreadsheet.

I will give this a try.
Thank you very much.

Browsing the links you posted gave me hope that there is a solution to this, but it is way above my capacity to learn. This is why people like me buy libraries and language enhancements. I really appreciate your input. I guess until more people are affected by the problem and it is resolved I'll hav...

Thanks, Wolfgang.
Your code is remarkably close to the method I am using with the exception that I use DC_Excel2Array to create the array.
I will try creating the array using just your Xbase code to see if makes a difference but I suspect, as was originally discussed, that Excel is the culprit.

Good suggestion about the csv file. Saving a spreadsheet in that format does yield text data correctly, and it could be easily manipulated, but getting an entire industry to change their pricing format from xls to csv, or trying to get everyone that uses my software to open every price sheet and sav...

Thanks, but it is not a format problem. The problem is that a character string in a spreadsheet cell, formatted as text, containing the data "12345", when converted to an array item, becomes "12345.0000" (text) in the array. The solution is not to truncate the decimal and zeros from the character st...

I use DC_Excel2Array because I have no idea how to extract one value from a cell in a spreadsheet and store it in a field, variable, or array. Is there a way to do this in Xbase? I could then write a function to somehow compare the length of the string, value, number of decimals, etc. and then make ...