=CALL("Xlcall32","Excel4","2JRJRR#",185,,2,24,B1) 
Author Message
 =CALL("Xlcall32","Excel4","2JRJRR#",185,,2,24,B1)

Hi, everyone.

My title is rather intricate. My question is about use of XML function
with CALL

 From Chip Pearson's web site, http://www.*-*-*.com/
---
=CALL("Xlcall32","Excel4","2JRJRR#",185,,2,18,A1)
returns the name of the font used in cell A1 (calls the GET.CELL function)

=CALL("Xlcall32","Excel4","2JRJRR#",185,,2,24,A1)
returns the color index of the first character in A1 (GET.CELL)

=CALL("Xlcall32","Excel4","2JRJRR#",185,,2,41,A1)
returns the formula in the cell A1 (GET.CELL)
---

The only difference among the above formula is the value of the second
last number; 18, 24, and 41. I wonder how to get the color index number
of background (fill) color. The second function gives the font color.

I also greatly appreciate if somebody could kindly give me the whole
list of CALL function usage with the change of the second last number
and all the rest unchanged like above (I know it would be extremely
stupendous if I ask for all the CALL function manual).

Thank you very much :-),  Tetsuya Oguma,  Sydney,  Australia



Tue, 19 Aug 2003 11:09:11 GMT  
 =CALL("Xlcall32","Excel4","2JRJRR#",185,,2,24,B1)
Better test it first.  Call has been disabled in later versiions of Excel 97
and in Excel 2000.

Regards,
Tom Ogilvy


Quote:
> Hi, everyone.

> My title is rather intricate. My question is about use of XML function
> with CALL

>  From Chip Pearson's web site, http://www.cpearson.com/excel/Call.htm
> ---
> =CALL("Xlcall32","Excel4","2JRJRR#",185,,2,18,A1)
> returns the name of the font used in cell A1 (calls the GET.CELL function)

> =CALL("Xlcall32","Excel4","2JRJRR#",185,,2,24,A1)
> returns the color index of the first character in A1 (GET.CELL)

> =CALL("Xlcall32","Excel4","2JRJRR#",185,,2,41,A1)
> returns the formula in the cell A1 (GET.CELL)
> ---

> The only difference among the above formula is the value of the second
> last number; 18, 24, and 41. I wonder how to get the color index number
> of background (fill) color. The second function gives the font color.

> I also greatly appreciate if somebody could kindly give me the whole
> list of CALL function usage with the change of the second last number
> and all the rest unchanged like above (I know it would be extremely
> stupendous if I ask for all the CALL function manual).

> Thank you very much :-),  Tetsuya Oguma,  Sydney,  Australia



Tue, 19 Aug 2003 12:58:26 GMT  
 =CALL("Xlcall32","Excel4","2JRJRR#",185,,2,24,B1)

Quote:
> Better test it first.  Call has been disabled in later versiions of Excel 97
> and in Excel 2000.

Thanks Tom for reminding me this. :-)  I am using Excel 97 SR-2  

Well, I might as well trash this method...
---
Tetsuya Oguma



Tue, 19 Aug 2003 13:11:01 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. DLookUp("[NEWRANK]","RankConversionTable ","[OLDRANK]"=[update]![rank])

2. MSWord / Switching Off All "Autoformat", "Autocorrect", "Autotext", Features

3. AnythingInThisList("Clin","Res","Gme","Ume","Admin")

4. HOW : Query Striping out ".", "LTD", "CORP", " ",ETC out of a NAME field

5. "abc", "def", export output from excel

6. replace(string, "x", "y")

7. =REGISTER("GENERIC.XLL","FUNC1")

8. GetObject("","InternetExplorer.Application") fails in Excel VBA

9. CreateObject("Excel","//server"), MsgBox output

10. "0"s entered in cells change to "1"s


 
Powered by phpBB® Forum Software © phpBB Group