Minggu, 20 Mei 2012

[smf_addin] Digest Number 2218

Messages In This Digest (6 Messages)

Messages

1.1.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Sat May 19, 2012 1:27 am (PDT)



Thanks Randy

> Please don't set your macro setting to Low -- it leaves you exposed to
> viruses, and won't make any difference to the add-in. The very fact
that
> you've added it via the Add-In Manger means it satisfies all security
> checks.

ok. got it . changed to a higher level

> I didn't want you to link to the URL from a cell, but enter the URL in
the
> address bar of the EXCEL Web Query dialog (keyboard shortcut
alt+d+d+w). I
> want to see if it redirects you or gives you some diagnostic message.

ok. did that . I got an internet explorer script error. Details below

First error
-----------------------------

" An error has occurred on the script on this page
Line : 43
Char : 4
Error : Expected identifier, string or number
Code : 0
URL : http://finance.yahoo.com/q?s=MMM
Do you want to continue running scripts on this page"
there are YES / NO buttons below

When I click YES, the second error comes up at a different line

Second error
-----------------------------

" An error has occurred on the script on this page
Line : 113
Char : 4
Error : "ll_js" is undefined
Code : 0
URL : http://finance.yahoo.com/q?s=MMM
Do you want to continue running scripts on this page"
there are YES / NO buttons below

When I click YES (to the second error as well) the web query appears,
with an IMPORT / CANCEL button

When I click "import", I get an XL sheet that I have uploaded to the
group files section at
http://f1.grp.yahoofs.com/v1/AFO3T7cdVEThHREKBpbN9jyfInMbvKyoV660IsjGruc\
q-ZdOszn8jZwukVod-mewiIVYB_b6U6Dm8Knj8ZYau-VKKIy0pI9Uqw8E/Uploads%20by%2\
0forum%20members/what%20I%20got%20using%20the%20web%20querry.xls
<http://f1.grp.yahoofs.com/v1/AFO3T7cdVEThHREKBpbN9jyfInMbvKyoV660IsjGru\
cq-ZdOszn8jZwukVod-mewiIVYB_b6U6Dm8Knj8ZYau-VKKIy0pI9Uqw8E/Uploads%20by%\
20forum%20members/what%20I%20got%20using%20the%20web%20querry.xls>

short URL http://bit.ly/Kn6bCx <http://bit.ly/Kn6bCx>

regards

Subu

>
> The add-in appears to be working, but accessing Yahoo is a problem.
>
> On Fri, May 18, 2012 at 10:19 PM, Subu S mail_to_subu@... wrote:
>
> >
> > You are amazing Randy
> >
> > > Looks like EXCEL isn't letting you get to Yahoo.
> >
> > Yes. I realise that Now :-(
> >
> > >Can you use the EXCEL Web
> > > Query dialog and navigate to this web page without a problem? Does
it
> > > redirect you, or do messages come up?
> > > http://finance.yahoo.com/q?s=MMM
> >
> > When I copy paste http://finance.yahoo.com/q?s=MMM to a cell in XL
and
> > hold the control key and click on the URL (within XL) nothing
happens !!
> >
> > So click hyperlink and open [from XL ] is not working !
> >
> > Other responses given below
> >
> > Command
> >
> > Result
> >
> > *http://finance.yahoo.com/q?s=MMM*
> >
> > *NO <http://finance.yahoo.com/q?s=MMM> response !!*
> >
> >
> > RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
> >
> >
> > =RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
> >
> > RCHGetWebData("http://www.google.com/finance?q=MMM",1,20)
> >
> > <!DOCTYPE html><html
> >
> >
> > I've ensured that the Stock Market functions add in is running
before I
> > tried the RCHGetTableCell / GetWebData functions & on my machine, XL
->
> > Tools -> Macro -> security level is set to "Low"
> >
> > So the question is : Is this some "options" parameter that I have
wrongly
> > set or accidentally changed ?
> >
> >
>

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

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Sat May 19, 2012 1:50 am (PDT)




Now !!

I try the getyahooquotes file again and it works !!

But I am quite sure it did NOT work few hours ago !!

did these webqueries or click URL from within XL open up something ??

puzzeled

regards
Subu

--- In smf_addin@yahoogroups.com, "Subu S" <mail_to_subu@...> wrote:
>
> Thanks Randy
>
> > Please don't set your macro setting to Low -- it leaves you exposed
to
> > viruses, and won't make any difference to the add-in. The very fact
> that
> > you've added it via the Add-In Manger means it satisfies all
security
> > checks.
>
> ok. got it . changed to a higher level
>
> > I didn't want you to link to the URL from a cell, but enter the URL
in
> the
> > address bar of the EXCEL Web Query dialog (keyboard shortcut
> alt+d+d+w). I
> > want to see if it redirects you or gives you some diagnostic
message.
>
> ok. did that . I got an internet explorer script error. Details below
>
> First error
> -----------------------------
>
> " An error has occurred on the script on this page
> Line : 43
> Char : 4
> Error : Expected identifier, string or number
> Code : 0
> URL : http://finance.yahoo.com/q?s=MMM
> Do you want to continue running scripts on this page"
> there are YES / NO buttons below
>
> When I click YES, the second error comes up at a different line
>
> Second error
> -----------------------------
>
> " An error has occurred on the script on this page
> Line : 113
> Char : 4
> Error : "ll_js" is undefined
> Code : 0
> URL : http://finance.yahoo.com/q?s=MMM
> Do you want to continue running scripts on this page"
> there are YES / NO buttons below
>
>
> When I click YES (to the second error as well) the web query appears,
> with an IMPORT / CANCEL button
>
> When I click "import", I get an XL sheet that I have uploaded to the
> group files section at
>
http://f1.grp.yahoofs.com/v1/AFO3T7cdVEThHREKBpbN9jyfInMbvKyoV660IsjGruc\
\
>
q-ZdOszn8jZwukVod-mewiIVYB_b6U6Dm8Knj8ZYau-VKKIy0pI9Uqw8E/Uploads%20by%2\
\
> 0forum%20members/what%20I%20got%20using%20the%20web%20querry.xls
>
<http://f1.grp.yahoofs.com/v1/AFO3T7cdVEThHREKBpbN9jyfInMbvKyoV660IsjGru\
\
>
cq-ZdOszn8jZwukVod-mewiIVYB_b6U6Dm8Knj8ZYau-VKKIy0pI9Uqw8E/Uploads%20by%\
\
> 20forum%20members/what%20I%20got%20using%20the%20web%20querry.xls>
>
> short URL http://bit.ly/Kn6bCx <http://bit.ly/Kn6bCx>
>
>
>
> regards
>
> Subu
>
>
>
>
> >
> > The add-in appears to be working, but accessing Yahoo is a problem.
> >
> > On Fri, May 18, 2012 at 10:19 PM, Subu S mail_to_subu@ wrote:
> >
> > >
> > > You are amazing Randy
> > >
> > > > Looks like EXCEL isn't letting you get to Yahoo.
> > >
> > > Yes. I realise that Now :-(
> > >
> > > >Can you use the EXCEL Web
> > > > Query dialog and navigate to this web page without a problem?
Does
> it
> > > > redirect you, or do messages come up?
> > > > http://finance.yahoo.com/q?s=MMM
> > >
> > > When I copy paste http://finance.yahoo.com/q?s=MMM to a cell in XL
> and
> > > hold the control key and click on the URL (within XL) nothing
> happens !!
> > >
> > > So click hyperlink and open [from XL ] is not working !
> > >
> > > Other responses given below
> > >
> > > Command
> > >
> > > Result
> > >
> > > *http://finance.yahoo.com/q?s=MMM*
> > >
> > > *NO <http://finance.yahoo.com/q?s=MMM> response !!*
> > >
> > >
> > > RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
> > >
> > >
> > > =RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
> > >
> > > RCHGetWebData("http://www.google.com/finance?q=MMM",1,20)
> > >
> > > <!DOCTYPE html><html
> > >
> > >
> > > I've ensured that the Stock Market functions add in is running
> before I
> > > tried the RCHGetTableCell / GetWebData functions & on my machine,
XL
> ->
> > > Tools -> Macro -> security level is set to "Low"
> > >
> > > So the question is : Is this some "options" parameter that I have
> wrongly
> > > set or accidentally changed ?
> > >
> > >
> >
>

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

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

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

Sat May 19, 2012 4:07 am (PDT)



The add-in access to web pages doesn't create or modify cookies, just read
them. So if a site needs to have a cookie created or modified, it needs to
be visited either by IE or via the EXCEL Web Query Dialog. By the way, you
didn't need to do an "Import". Just visit the web page. So you could have
canceled out of the web query after opening the web page.

But this is the result I was hoping for and why I wanted you to open up the
web page.

Great.

On Sat, May 19, 2012 at 1:50 AM, Subu S <mail_to_subu@yahoo.com> wrote:

>
> Now !!
>
> I try the getyahooquotes file again and it works !!
>
> But I am quite sure it did NOT work few hours ago !!
>
> did these webqueries or click URL from within XL open up something ??
>
> puzzeled
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (59)
1.4.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Sat May 19, 2012 9:29 am (PDT)



Thanks Randy

It all makes sense now *after* you have explained !

Best regards

Subu

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in access to web pages doesn't create or modify cookies, just read
> them. So if a site needs to have a cookie created or modified, it needs to
> be visited either by IE or via the EXCEL Web Query Dialog. By the way, you
> didn't need to do an "Import". Just visit the web page. So you could have
> canceled out of the web query after opening the web page.
>
> But this is the result I was hoping for and why I wanted you to open up the
> web page.
>
> Great.
>
> On Sat, May 19, 2012 at 1:50 AM, Subu S <mail_to_subu@...> wrote:
>
> >
> > Now !!
> >
> > I try the getyahooquotes file again and it works !!
> >
> > But I am quite sure it did NOT work few hours ago !!
> >
> > did these webqueries or click URL from within XL open up something ??
> >
> > puzzeled
> >
>

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

Re: RCHGetElementnumber: result all are undefined

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

Sat May 19, 2012 2:45 pm (PDT)



I'm using excel 2010 on both my laptop and my desktop. I downloaded the add in on my desktop (all my work was originally done on the laptop, and i want to be able to use both) I then saved the file as directed with the elements in the same directory. First I received the NAME error which I resolved by deleting extra coding as suggested, but then I received the undefined error. As far as I can tell all of the external element definitions are saved in the same area, but I can't get past this error. Any more suggestions?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> "Undefined" typically means you don't have the element definition files in
> the same directory as the add-in -- the "smf-elements-n.txt" files. Most of
> the element definitions are EXTERNAL to the add-in, for easier update.
> That's why the installation instructions says to "extract all of the files
> from the ZIP archive".
>
> On Sat, Mar 19, 2011 at 1:29 AM, hahahawakakaka <nevilleyhs@...>wrote:
>
> > RCHGetElementnumber: result all are undefined
> >
> > quote i used: IBM
> > template: 10 Year Financial Summary.xls
> >
>

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

Re: RCHGetElementnumber: result all are undefined

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

Sat May 19, 2012 2:54 pm (PDT)



The element definitions were there BEFORE you tried to use them? Placing
them in the directory afterwards will not fix the "undefined" unless you
exit and restart EXCEL (or use the smfForceRecalculation macro), because
they typically are only loaded once.

Otherwise, if all files were in the SMF folder when you started EXCEL, I am
at a loss to explain why you are getting undefined for all elements.

What do you get with:

=RCHGetElementNumber("Version")

On Sat, May 19, 2012 at 2:42 PM, jmattgoldberg <jmattgoldberg@yahoo.com>wrote:

> I'm using excel 2010 on both my laptop and my desktop. I downloaded the
> add in on my desktop (all my work was originally done on the laptop, and i
> want to be able to use both) I then saved the file as directed with the
> elements in the same directory. First I received the NAME error which I
> resolved by deleting extra coding as suggested, but then I received the
> undefined error. As far as I can tell all of the external element
> definitions are saved in the same area, but I can't get past this error.
> Any more suggestions?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.15

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)