Messages In This Digest (3 Messages)

Messages

1a.: RCHGetYahooHistory() stopped working?

Posted by: "fdtseng" e11years@gmail.com fdtseng

Wed Mar 7, 2012 10:20 am (PST)

Used to work okay with Excel 2010 and Windows 7. However since today it stopped with the cells filled with "#NAME?". The example file in the links directory also displays the same problem.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: RCHGetYahooHistory() stopped working?

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 7, 2012 12:52 pm (PST)

Sounds like either the add-in is no longer installed, or you have location
errors (see the "Links" area of the Yahoo group for the resolution of this).

On Wed, Mar 7, 2012 at 10:50 AM, fdtseng <e11years@gmail.com> wrote:

> Used to work okay with Excel 2010 and Windows 7. However since today it
> stopped with the cells filled with "#NAME?". The example file in the links
> directory also displays the same problem.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.: Re: Trend Values for http://www.masterdata.com/

Posted by: "smithjhhic" smithjhhic@yahoo.com smithjhhic

Wed Mar 7, 2012 4:41 pm (PST)

Randy,
Thank you very much for your help.
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just do:
>
> =SUBSTITUTE(...formula...,"&nbsp","")
>
> On Tue, Mar 6, 2012 at 4:34 PM, smithjhhic <smithjhhic@...> wrote:
>
> >
> > Thank you for your help. I'm an Excel novice. How do I add the
> > substitute function into the two formulas below?
> >
> > =RCHGetTableCell("http://www.masterdata.com/ComponentFrames/"&LEFT(B8,1)&"/"&B8&".htm",2,">Current
> > Trend")
> >
> > =RCHGetElementNumber($C2,702)
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

Messages | Files | Photos | Polls