1. ## Excel Functions

User Roger Lane (Roger.Lane@ibpinc.com) posted:

Sombody help me.
I'm looking for all of the really cool excel functions that someone wrote
and I can't find them. If anyone can point me in the right direction, I
would greatly appreciate it.
TIA
Roger Lane

---

2. ## Re: Excel Functions

User Kai Schrimpf (kai.schrimpf@db.com) posted:

Hi,

go to :
http://groups.yahoo.com/group/Ration...les/Libraries/

you have to be user of the Yahoo Group to get to it.

Thanks.
Kai Schrimpf
-------------------------------------------------------------------------------------------
"The great thing about being the only species that makes
a distinction between right and wrong is that we can make
up the rules for ourselves as we go along. "
-------------------------------------------------------------------------------------------

---------------------------------------- Message History ----------------------------------------

From: "Roger Lane" <Roger.Lane@ibpinc.com> on 04/23/2001 01:23 PM AST

Please respond to "SQA Suite Team Test Users" <sqa-suite-users@lyris.dundee.net>

To: "SQA Suite Team Test Users" <sqa-suite-users@lyris.dundee.net>
cc:
Subject: Excel Functions

Sombody help me.
I'm looking for all of the really cool excel functions that someone wrote
and I can't find them. If anyone can point me in the right direction, I
would greatly appreciate it.
TIA
Roger Lane

---

3. ## Re: Excel Functions

User Jon Christensen (jtchrist@hewitt.com) posted:
I am having all sorts of trouble using ReadExcelDataSingle from the Excel
library. I have made no changes. Most of the time it works fine and reads the
value of the cell that I ask for but every now and then I have been getting
Error 440: Object method returned an unsupported data type. All of the cells
that I am reading are formulas for the text but the value is a number. One of
the cell's formula's is:

=MAX(0,ROUNDDOWN((B14*3+C14*4+D14*5)*div_per_share/D11,0)-D13)

and the value in the cell is 108.

What does this error mean? Is there anything I can change to get that value?

---

4. ## Re: Excel Functions

User Andy Tinkham (tinkha@visi.com) posted:

What version of Excel are you using? What version of the Excel functions?

The error means that Excel is storing the 108 in a format different than
Robot can handle... Select the cell and choose Cells... from the Format
menu (or the equivalent in your version of Excel, I'm working from Excel
2000 here). What's selected there on the Number tab?

There are three ways you may be able to fix this:
1) If something less common is selected in the Format Cells dialog Number
tab, change that to a more common value, if you can.
=TEXT(MAX(0,ROUNDDOWN((B14*3+C14*4+D14*5)*div_per_ share/D11,0)-D13),"#")
This explicitly changes the value to text, which Robot should be able to
pull out without a problem. If the 108 value is used in other formulas
though, you'll either need to specifically convert it back to a number (with
the VALUE function) or change the other formulas, so probably not the best
solution then.
3) Change the ReadExcelDataSingle routine. In it, there's a line that says:

sData = objWorkSheet.Range(sCell).Value

sData = objWorkSheet.Range(sCell).Value2

The Value2 parameter is the same as Value except it doesn't return the
Currency or Date data types. I don't know if this will help or not. I
haven't seen this error pop up in a long time (not since I was writing the
routines, truthfully), so I'm a bit at a loss as to why its occurring. If
you try any of these, I'd like to hear how they work for you, please, either
here or direct at andy@tinkham.org.

Good luck!

Andy

5. ## Re: Excel Functions

IN the Excel.zip there is no sqautil.sbl file so where to get that file from which is used in the excel.sbh as include file

------------------

6. ## Re: Excel Functions

User Roger Lane (Roger.Lane@ibpinc.com) posted:

Sombody help me.
I'm looking for all of the really cool excel functions that someone wrote
and I can't find them. If anyone can point me in the right direction, I
would greatly appreciate it.
TIA
Roger Lane

Hi Roger

'Sanjeev'

------------------
"I am an idealist, but don't know which way I am heading towards "

7. ## Re: Excel Functions

sqautil comes with Robot and will be in your common directory or for instance a copy is in ...Program Files\Rational\Rational Test 7\sqabas32

Max

------------------

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.