My following lines of code give me error :
Code :
oExcel := Win_OLECreateObject( "Excel.Application" )
oExcel:Workbooks:Open("abc.xls")
::oExcel:Visible := .T.
oAS := oExcel:ActiveSheet()
oAS:Cells ( 1, 3 ):Interior:ColorIndex := 7
Error :
Subsystem Call: WINOLE
System Code: 1006
Default Status: .F.
Description: (0x800A03EC)
Operation: _COLORINDEX
Arguments: [ 1] = Type: N Val: 7
Involved File:
Dos Error Code: -2147352567
Any idea, What am I doing wrong ?
TIA
Milan.
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Win_Ole Error, Dos Error Code: -2147352567
-
- Mensajes: 133
- Registrado: Dom Dic 27, 2009 9:54 am
Win_Ole Error, Dos Error Code: -2147352567
Milan,
> My following lines of code give me error :
>
> Code :
> oExcel := Win_OLECreateObject( "Excel.Application" )
> oExcel:Workbooks:Open("abc.xls")
> ::oExcel:Visible := .T.
> oAS := oExcel:ActiveSheet()
> oAS:Cells ( 1, 3 ):Interior:ColorIndex := 7
>
> Error :
> Subsystem Call: WINOLE
> System Code: 1006
> Default Status: .F.
> Description: (0x800A03EC)
> Operation: _COLORINDEX
> Arguments: [ 1] = Type: N Val: 7
> Involved File: Dos Error Code: -2147352567
>
> Any idea, What am I doing wrong ?
this error report is not from a Xailer application.
Please, test it from a Xailer program, and use TOleAuto() instead of
Win_OLECreateObject()
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
> My following lines of code give me error :
>
> Code :
> oExcel := Win_OLECreateObject( "Excel.Application" )
> oExcel:Workbooks:Open("abc.xls")
> ::oExcel:Visible := .T.
> oAS := oExcel:ActiveSheet()
> oAS:Cells ( 1, 3 ):Interior:ColorIndex := 7
>
> Error :
> Subsystem Call: WINOLE
> System Code: 1006
> Default Status: .F.
> Description: (0x800A03EC)
> Operation: _COLORINDEX
> Arguments: [ 1] = Type: N Val: 7
> Involved File: Dos Error Code: -2147352567
>
> Any idea, What am I doing wrong ?
this error report is not from a Xailer application.
Please, test it from a Xailer program, and use TOleAuto() instead of
Win_OLECreateObject()
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info