2 Messages

Digest #4165

Re: Elements 1285 & 1290 and Earnings by ssztaba

Re: Elements 1285 & 1290 and Earnings by "Randy Harmelink" rharmelink

Messages

1a

Re: Elements 1285 & 1290 and Earnings

Wed Oct 4, 2017 5:09 am (PDT) . Posted by:

ssztaba

C4: =C3+1
D4: =""""&REPT("A",C4)&""""
E4: =smfEval(D4)

Then just copy those down several hundred rows. At some point, the value in column E should change to #VALUE!. Add 2 to the value that row's column C (because of the two double quotes in the string) and you'll know the EXCEL 2002 limit. I'm curious what it is. I would suspect 128. Such limitations are usually based on factors of 2 because it's all based on a binary number system.

So any element definition formula longer than that length will return "Error" for EXCEL 2002.

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

When the C value (in C254 -- beginning at C4) shows '254' the E shows "#Value" for the first time.

Thus 254 + 2 = 256 as the limit for Excel 2002.

But 256 is larger than the 177 length I got doing the
=smfEval(SUBSTITUTE(D6,"~~~~~","MCD")) routine ???

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1b

Re: Elements 1285 & 1290 and Earnings

Wed Oct 4, 2017 10:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmm. It has to be related to how EXCEL 2002 is limiting that Evaluate() in
VBA. Try this in D6:

smfWord(RCHGetWebData("
https://www.zacks.com/stock/research/~~~~~/earnings-announcements","document.obj_data
= {"),3,"[")

...and this in D7:

=smfEval(SUBSTITUTE(D6,"~~~~~","MCD"))

As before, you should get #VALUE!. Now change D6 to be:

smfWord(RCHGetWebData("
https://www.zacks.com/stock/research/~~~~~/earnings-announcements","document.obj_data
= {",255),3,"[")

What do you have now in D7?

How about if cell D6 has:

left(RCHGetWebData("
https://www.zacks.com/stock/research/~~~~~/earnings-announcements","document.obj_data
= {"),255)

What I'm thinking is that the RCHGetWebData() is returning a long string
(up to 32767 bytes). Maybe EXCEL 2002 can't handle that.

On Wed, Oct 4, 2017 at 5:09 AM, ssztaba@
...
wrote:

>
> C4: =C3+1
> D4: =""""&REPT("A",C4)&""""
> E4: =smfEval(D4)
>
> Then just copy those down several hundred rows. At some point, the value
> in column E should change to #VALUE!. Add 2 to the value that row's column
> C (because of the two double quotes in the string) and you'll know the
> EXCEL 2002 limit. I'm curious what it is. I would suspect 128. Such
> limitations are usually based on factors of 2 because it's all based on a
> binary number system.
>
> So any element definition formula longer than that length will return
> "Error" for EXCEL 2002.
>
> ------------------------------
>
> When the C value (in C254 -- beginning at C4) shows '254' the E shows
> "#Value" for the first time.
>
> Thus 254 + 2 = 256 as the limit for Excel 2002.
>
> But 256 is larger than the 177 length I got doing the
> =smfEval(SUBSTITUTE(D6,"~~~~~","MCD")) routine ???
>
>
>
>
>
>