Kamis, 11 Juni 2015

[smf_addin] Digest Number 3430

3 Messages

Digest #3430

Messages

Wed Jun 10, 2015 4:27 am (PDT) . Posted by:

smmarder

The above is my new problem. I left for a two week vacation and now the field do not work at all?? The cells that have =RCHGetYahooQuotes(C1,"l1") as an entry reply either Error or are blank.

Using Randy's sugesstion when I enter the suggested:

If you're in EXCEL, exit and restart. In a brand new workbook, what do you get with:


=RCHGetElementNumber("MMM";,942)

=RCHGetYahooQuotes("MMM","l1")

=RCHGetElementNumber("Version")

I get

#NAME? as the response in all cells.

Any help will be very greatly appreciated, as I use this excelent add in every day.
Thanks
Sid

Wed Jun 10, 2015 6:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The most likely reason for #NAME? is that the add-in is no longer
installed. Check the add-in manager and make sure it's still listed there
with a check mark on it.

On Wed, Jun 10, 2015 at 4:27 AM, smmarder@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> The above is my new problem. I left for a two week vacation and now the
> field do not work at all?? The cells that have =RCHGetYahooQuotes(C1,"l1")
> as an entry reply either Error or are blank.
>
> Using Randy's sugesstion when I enter the suggested:
>
> If you're in EXCEL, exit and restart. In a brand new workbook, what do you
> get with:
>
> =RCHGetElementNumber("MMM";,942)
> =RCHGetYahooQuotes("MMM","l1")
> =RCHGetElementNumber("Version&quot;)
>
> I get
>
> #NAME? as the response in all cells.
>
> Any help will be very greatly appreciated, as I use this excelent add in
> every day.
> Thanks
> Sid
>
>

Wed Jun 10, 2015 6:48 am (PDT) . Posted by:

sirons1962

After your very gracious teaching of how to grab the data from the IFRAMES I decided to utilize that to populate the spreadsheet I am using.

Extremely thankful that you share your expertise with us in this group.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar