[jawsscripts] Re: using com objects in jaws scripting and excel
- From: Chad Foster <chad.foster@xxxxxxxxxx>
- To: jawsscripts@xxxxxxxxxxxxx
- Date: Mon, 28 Sep 2009 11:57:24 -0400
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
Other related posts:
