The problem is this excel 97 fiel is to be imported - from within the application - Is it possible for Fox to call Excel and do some cleanup (Edit - Select All - Copy - Paste Special - Values) or alternatively invoke Excel from within the app - open the file and save in a lower version of Excel and return back to the application and upload the modified file. I mean - the user need not open excel and save the Excel sheet in a lower version - explicitly. There is an issue exporting to Excel 97 with VFP 6.0 - It is really surprising such problems have not come to light. I would be glad if u could help.
Extract of my message to Sergey
Quote
"
Sergey,
When i even try to upload this Excel file from the command prompt in VFP6.0 using the command
append from filename.xls type xls
Fox responds with the message - Fatal error - Exception code C0000005
Also, when i use the .exe runs the error message is
Fatal Error - Exception code C0000005
Called from - form1.command1.click Line 10 {g:\almexe\upload.sct}
Called from - main line 12 {g:\almexe\main.prg}
Code associated with form1.command1.click
** asking the user for the input file and storing the name to a global variable
close tables
PUBLIC gctable
gctable = GETFILE('XLS', 'Browse:', 'Browse', 0, 'Browse')
THISFORM.text1.VALUE = gctable
**Calling the validation process to determine the field lengths
use combmail
zap
append from '&gctable' type xls
dele all for day = 0
pack
close tables
**If the user decides to conitnue enabling the upload option
THISFORM.command2.ENABLED=.T.
THISFORM.command2.SETFOCUS
P.S. - I can send u the screen dumps if u can give me your e-mail id. Basically, the issue here is that VFP 6.0 - append from command does not import the Excel 97 file format. Even copy to filename.xls type xls - does not export the output of the table to Excel 97.
" Unquote
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement