[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 13:35:22 -0300
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
Other related posts:
