Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Foxypreviewer don't release excell
Message
From
07/12/2011 12:42:54
 
 
To
07/12/2011 12:24:27
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01530369
Message ID:
01530543
Views:
60
>>César, with version 2.88 behaves the same previous version. Following my code. This piece of code is inside SCAN, because I am generating several XLS files. To work fine I have to omit parameter "xlExcel9795" on the line loExcel.ActiveWorkbook.SaveAs(m.nmPlanilha+'.XLS', xlExcel9795).
>>
>>I have #DEFINE xlExcel9795 43 before SCAN. Maybe I am doing something wrong
>>
>>DO FOXYPREVIEWER.APP
>>REPORT FORM relrepassecdlxcdl OBJECT TYPE 13 TO FILE (m.nmPlanilha+'.XML')
>>DO FOXYPREVIEWER.APP WITH 'Release'
>>IF !FILE(m.nmPlanilha+'.XML')
>> MESSAGEBOX('Ocorreu um problema e não foi possível gerar a planilha no formato XML',48,'Atenção')
>> EXIT
>>ELSE
>> loExcel.Workbooks.Open(m.nmPlanilha+'.XML')
>> loExcel.ActiveWorkbook.SaveAs(m.nmPlanilha+'.XLS', xlExcel9795)
>> loExcel.ActiveWindow.Close(.T.)
>> IF !FILE(m.nmPlanilha+'.XLS')
>> MESSAGEBOX('Ocorreu um problema e não foi possível gerar a planilha no formato XLS',48,'Atenção')
>> EXIT
>> ENDIF
>>ENDIF
>>
>>After the XLS file is generated when I open with excel 2007 appears message "The file you are trying to open is on different format of specified by extension of the file. Verify if the file is corrupted and ...."
>>I confirm YES and the file is OK.
>
>Something is strange...
>in v2.88a I removed the 2nd parameter, as you suggested.
>Please, to confirm that, open the preferences window, at the bottom left side you'll find in blue the current version.

César,
Note that in my code I am not using REPORT PREVIEW, but as you asked, I changed my code to see the version, and the version is v2.88a ALPHA 2011.12.06
Antonio Carlos Kleinübing
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform