[jawsscripts] Re: using com objects in jaws scripting and excel
- From: Marlon Brandão de Sousa <splyt.lists@xxxxxxxxx>
- To: jawsscripts@xxxxxxxxxxxxx
- Date: Mon, 28 Sep 2009 16:03:45 -0300
Thanks a lot.
If some of you could test the code I wrote and posted here in
different versions of JAWS and report ... I can not figure out why it
is running in JAWS 9 and not in JAWS 6...
Thanks again!
Marlon
2009/9/28, Chad Foster <chad.foster@xxxxxxxxxx>:
> 1. No, you cannot. You will have to use the wrapper function or define
> your own global variable and assign it to the wrapper function's
> output.
> 2. Using the wrapper function enables you to use the built-in Freedom
> Scientific function without worrying about it being properly
> documented in the associated documentation (JSD) file. The binary file
> (JSB) and documentation file (JSD) are not always synchronized.
>
> -C
>
> On 9/28/09, Marlon Brandão de Sousa <splyt.lists@xxxxxxxxx> wrote:
>> Hello Xad,
>> Two questions:
>> 1- in the module xlFunc.jsb there is an autostartEvent that makes a
>> global object called oExcel available and initialized to the default
>> excel application object, accordingly with the documentation in
>> xlFunc.jsd.
>> I tried to use the oExcel object from within the microsoft excel.jss
>> but werent able to do so * the compiler complained about a not defined
>> oExcel variable. So .. can't I use a global variable defined in a jsb
>> module from outside it even if the current module has a use statement
>> ponting to the module where this global variable is defined?
>>
>> 2- What would be the advantages of using a wrapper function such as
>> this one you suggested?
>>
>> Thanks,
>> Marlon
>>
>> 2009/9/28, Chad Foster <chad.foster@xxxxxxxxxx>:
>>> Yes, it should. You may want to write a wrapper function for the
>>> GetExcelObject function though. Like:
>>>
>>> Object Function GetExcelObject ()
>>> return GetExcelObject ()
>>> endFunction
>>>
>>>
>>> On 9/28/09, Marlon Brandão de Sousa <splyt.lists@xxxxxxxxx> wrote:
>>>> Hello,
>>>> I will report soon a set of scripts that I have developped to enhance
>>>> excel usability. I have found several functions compiled in the
>>>> xlFunc.jsb module. These functions don't appear in the insert function
>>>> dialog although the microsoft excel.jss has a use "xlFunc.jsb"
>>>> statement.
>>>> I then looked into the JAWS shared settings and found a file
>>>> xlFunc.jsd from where I got the function specs for this module and
>>>> have cinse then make a extensive use of that stuff.
>>>> For now, my question is the following:
>>>> JAWS 9 has a function called moveToCell in the xlFunc.jsb module and I
>>>> am using this function. Unfortunately JAWS 6 doesn't have this
>>>> function available, so I need to build a similar function, cinse I
>>>> need to support JAWS 6.
>>>> I developped the following similar function:
>>>>
>>>> function focusCell(string sCoordinates)
>>>> var
>>>> object oExcelTable,
>>>> object oNull
>>>> let oexcelTable = getObject("excel.application")
>>>> if(!oExcelTable)
>>>> saystring("can not get the excel application object")
>>>> return
>>>> endIf
>>>> ;move to a1 cell of the current worksheet
>>>> excelTable.range("a1").select()
>>>> let oExcelTable = oNull
>>>> endFunction
>>>>
>>>> This code compiles and runs wonderfully on JAWS 9 (called by a script)
>>>> but wont run in JAWS 6 where I need it, although it compiles and
>>>> passes the test of checking if oExcelTable was created. Why? If a call
>>>> to a com function works in JAWS 9, it should work in every other
>>>> version that support com automation rigt?
>>>>
>>>> Thanks,
>>>> Marlon
>>>>
>>>> --
>>>> When you say "I wrote a program that crashed Windows," people just
>>>> stare at you blankly and say "Hey, I got those with the system, for
>>>> free."
>>>> Linus Torvalds
>>>> __________
>>>> Visit and contribute to The JAWS Script Repository
>>>> http://jawsscripts.com
>>>>
>>>> View the list's information and change your settings at
>>>> //www.freelists.org/list/jawsscripts
>>>>
>>>>
>>>
>>>
>>> --
>>> Chad Foster
>>> Access Technology Solutions
>>> Leveling The Playing Field Through Technology
>>> http://www.GO-ATS.net
>>> __________
>>> Visit and contribute to The JAWS Script Repository http://jawsscripts.com
>>>
>>> View the list's information and change your settings at
>>> //www.freelists.org/list/jawsscripts
>>>
>>>
>>
>>
>> --
>> When you say "I wrote a program that crashed Windows," people just
>> stare at you blankly and say "Hey, I got those with the system, for
>> free."
>> Linus Torvalds
>> __________
>> Visit and contribute to The JAWS Script Repository http://jawsscripts.com
>>
>> View the list's information and change your settings at
>> //www.freelists.org/list/jawsscripts
>>
>>
>
>
> --
> Chad Foster
> Access Technology Solutions
> Leveling The Playing Field Through Technology
> http://www.GO-ATS.net
> __________
> Visit and contribute to The JAWS Script Repository http://jawsscripts.com
>
> View the list's information and change your settings at
> //www.freelists.org/list/jawsscripts
>
>
--
When you say "I wrote a program that crashed Windows," people just
stare at you blankly and say "Hey, I got those with the system, for
free."
Linus Torvalds
__________
Visit and contribute to The JAWS Script Repository http://jawsscripts.com
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
Other related posts:
