Kbase P176403: Can't open an MS Excel file with Office 2007
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/2/2010 |
|
Status: Unverified
SYMPTOM(s):
Can't open an MS Excel file with Office 2007
Client Workstations were upgraded to MS Office 2007
Client Workstations had installed MS Office 2003
No errors are reported
FACT(s) (Environment):
MS Excel method Workbooks:OpenText
No changes in 4GL program
Works with MS Office 2000
Windows XP Professional SP3
Progress 9.1D
OpenEdge 10.1B
OpenEdge Category: Language (4GL/ABL)
CAUSE:
OpenText method in the Microsoft Excel 2000 version has 15 parameters and 3 more parameters were added in MS Excel 2007. The parameter expected after "FieldInfo" is DecimalSeparator and ThousandSeparator in Excel 2000, but in Excel 2007 there is a new parameter after "fieldInfo" called TextVisualLayout. Also in Excel 2007 if a parameter doesn't have any value and double-quotes is used without anything in them an error will be generated.
FIX:
If parameter TextVisualLayout is not used then just leave it blank. Make sure all double-quotes without any value in it used in Excel 2000 are removed.