Alaska Software Inc. - Errors on using ActiveX
Username: Password:
AuthorTopic: Errors on using ActiveX
Regan Cawkwell Errors on using ActiveX
on Thu, 14 Jan 2010 13:45:00 +0000
Hi guys

We repeatedly get errors that say the subsystem is 'Automation'.

Is it possible that the errors are due to features/functions being used via the ActiveX 
components that do not exist in the version of the software on the customers PC?

For instance, the following error log came from one of our customers:

------------------------------------------------------------------------------
ERROR LOG of "c:\rba\rba32.exe" Date: 14/01/2010 13:30:05

Xbase++ version:Xbase++ (R) Version 1.90.331
Operating system:Windows Vista 06.00 Build 06002 Service Pack 2
------------------------------------------------------------------------------
oError:args         :-> VALTYPE: C - VALUE: AutoFit
oError:canDefault   :.T.
oError:canRetry     :.F.
oError:canSubstitute:.T.
oError:cargo        :NIL
oError:description  :
oError:filename     :NIL
oError:genCode      :NIL
oError:operation    :AutoFit
oError:osCode       :-2146777998
oError:severity     :2
oError:subCode      :6500
oError:subSystem    :Automation
oError:thread       :5
oError:tries        :NIL
------------------------------------------------------------------------------

The code that this happens on is the middle line in the loop:

    for i=2 to len(aDATA[1])
      oSheet:Columns( i ):AutoFit()
    next

Could it be that the 'Autofit' function does not exist in some versions of Excel?

Or does anyone know any other reason why an error like this might occur?

Regan Cawkwell
Company  : Real Business Applications Ltd
Title    : Technical Support
Websites : www.rbauk.com
Email    : regan@rbauk.com
------------------------------------------------------
Jorge LRe: Errors on using ActiveX
on Thu, 14 Jan 2010 12:25:52 -0300
Hi

i had this error when the user open the excel file from a deep location ( ie 
c:\doument and setting\escritorio\proveedores\consignaciones del 2009.xls )

"Regan Cawkwell" <regan@rbauk.com> escribió en el mensaje de noticias 
news:1a22c7a8$7758e232$5e380@news.alaska-software.com...
> Hi guys
>
> We repeatedly get errors that say the subsystem is 'Automation'.
>
> Is it possible that the errors are due to features/functions being used 
> via the ActiveX components that do not exist in the version of the 
> software on the customers PC?
>
> For instance, the following error log came from one of our customers:
>
> ------------------------------------------------------------------------------
> ERROR LOG of "c:\rba\rba32.exe" Date: 14/01/2010 13:30:05
>
> Xbase++ version:Xbase++ (R) Version 1.90.331
> Operating system:Windows Vista 06.00 Build 06002 Service Pack 2
> ------------------------------------------------------------------------------
> oError:args         :-> VALTYPE: C - VALUE: AutoFit
> oError:canDefault   :.T.
> oError:canRetry     :.F.
> oError:canSubstitute:.T.
> oError:cargo        :NIL
> oError:description  :
> oError:filename     :NIL
> oError:genCode      :NIL
> oError:operation    :AutoFit
> oError:osCode       :-2146777998
> oError:severity     :2
> oError:subCode      :6500
> oError:subSystem    :Automation
> oError:thread       :5
> oError:tries        :NIL
> ------------------------------------------------------------------------------
>
> The code that this happens on is the middle line in the loop:
>
>    for i=2 to len(aDATA[1])
>      oSheet:Columns( i ):AutoFit()
>    next
>
> Could it be that the 'Autofit' function does not exist in some versions of 
> Excel?
>
> Or does anyone know any other reason why an error like this might occur?
>
> -- 
> Regan Cawkwell
> Company  : Real Business Applications Ltd
> Title    : Technical Support
> Websites : www.rbauk.com
> Email    : regan@rbauk.com
> ------------------------------------------------------
>