Kamis, 29 September 2011

[smf_addin] Digest Number 1969

Messages In This Digest (9 Messages)

Messages

1a.

Re: RCHGetYahooQuotes not working on certain tickers

Posted by: "KailuaKid" Gary.Hartling@gmail.com   garyhartling

Wed Sep 28, 2011 6:39 am (PDT)



Yahoo quotes seem to be working for me this morning. --gh

--- In smf_addin@yahoogroups.com, "zaigrith" <adam.schoenwald@...> wrote:
>
> I noticed that =RCHGetYahooQuotes("nwn","l1",,NOW()) is returning 0, while the prices on yahoo are working. Any thoughts on why this is happening. Everything was working fine a few days ago and i have not changed the file. Problem occurs with older files that used to work and on different computers.
>

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

Re: RCHGetYahooQuotes not working on certain tickers

Posted by: "Glen Fullmer" gfullmer@cox.net   gfullmer

Wed Sep 28, 2011 6:51 am (PDT)



On Wed, 2011-09-28 at 13:39 +0000, KailuaKid wrote:
>
> Yahoo quotes seem to be working for me this morning. --gh

Seems like all the input helped them. Thanks. I needed that!

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

Please help: keep getting windows security alarm

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

Wed Sep 28, 2011 2:35 pm (PDT)



Hi Randy,

thanks for all the knowledge you shared with us. i am recently trying to get data from web site by Rchgettablecell ,but i keep getting windows security alarm (to allow website to provide personalized information to you ,could we put a little cookie in your computer ?)

i hit yes or no ,but this alarm still keep popping up .

excel 2007 and windows 7

do you have any suggestion about this ?thanks .

have a good day!

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

Re: Please help: keep getting windows security alarm

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

Wed Sep 28, 2011 2:45 pm (PDT)



The add-in uses the same Internet engine as IE, so it uses IE's cookies and
Temporary Internet Files. If you have something that alerts you to changes
there, the add-in retrieval of web pages will trigger those alerts...

I'm assuming you don't use IE as a browser, or I'd think you should be
getting such alerts all the time.

On Wed, Sep 28, 2011 at 2:08 PM, xjiaan <xjiaan@yahoo.com> wrote:

> Hi Randy,
>
> thanks for all the knowledge you shared with us. i am recently trying to
> get data from web site by Rchgettablecell ,but i keep getting windows
> security alarm (to allow website to provide personalized information to you
> ,could we put a little cookie in your computer ?)
>
> i hit yes or no ,but this alarm still keep popping up .
>
> excel 2007 and windows 7
>
> do you have any suggestion about this ?thanks .
>
> have a good day!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2c.

Re: Please help: keep getting windows security alarm

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

Wed Sep 28, 2011 3:11 pm (PDT)




exactly ,i use firefox as default IE brower. so the solution is use IE as default brower ? am i right ?thank you so much.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in uses the same Internet engine as IE, so it uses IE's cookies and
> Temporary Internet Files. If you have something that alerts you to changes
> there, the add-in retrieval of web pages will trigger those alerts...
>
> I'm assuming you don't use IE as a browser, or I'd think you should be
> getting such alerts all the time.
>
> On Wed, Sep 28, 2011 at 2:08 PM, xjiaan <xjiaan@...> wrote:
>
> > Hi Randy,
> >
> > thanks for all the knowledge you shared with us. i am recently trying to
> > get data from web site by Rchgettablecell ,but i keep getting windows
> > security alarm (to allow website to provide personalized information to you
> > ,could we put a little cookie in your computer ?)
> >
> > i hit yes or no ,but this alarm still keep popping up .
> >
> > excel 2007 and windows 7
> >
> > do you have any suggestion about this ?thanks .
> >
> > have a good day!
> >
>

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

Re: Please help: keep getting windows security alarm

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

Wed Sep 28, 2011 3:24 pm (PDT)



No. I also use FireFox as my browser. I almost never use IE as a browser.

But you have to be aware that whatever alerts you put on IE activities might
be triggered when the add-in gets data -- BECAUSE it uses the same Internet
access function library as IE. IE settings apply to EXCEL and add-in
accesses to the Internet. Neither the EXCEL Web Query or the add-in will
care that you use FireFox as your default browser.

On Wed, Sep 28, 2011 at 3:11 PM, xjiaan <xjiaan@yahoo.com> wrote:

>
> exactly ,i use firefox as default IE brower. so the solution is use IE as
> default brower ? am i right ?thank you so much.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > The add-in uses the same Internet engine as IE, so it uses IE's cookies
> and
> > Temporary Internet Files. If you have something that alerts you to
> changes
> > there, the add-in retrieval of web pages will trigger those alerts...
> >
> > I'm assuming you don't use IE as a browser, or I'd think you should be
> > getting such alerts all the time.
> >
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2e.

Re: Please help: keep getting windows security alarm

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

Wed Sep 28, 2011 3:35 pm (PDT)



thanks!
so i need change the security setting of IE ,because EXCEL use the same configuration as IE ?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> No. I also use FireFox as my browser. I almost never use IE as a browser.
>
> But you have to be aware that whatever alerts you put on IE activities might
> be triggered when the add-in gets data -- BECAUSE it uses the same Internet
> access function library as IE. IE settings apply to EXCEL and add-in
> accesses to the Internet. Neither the EXCEL Web Query or the add-in will
> care that you use FireFox as your default browser.
>
> On Wed, Sep 28, 2011 at 3:11 PM, xjiaan <xjiaan@...> wrote:
>
> >
> > exactly ,i use firefox as default IE brower. so the solution is use IE as
> > default brower ? am i right ?thank you so much.
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > The add-in uses the same Internet engine as IE, so it uses IE's cookies
> > and
> > > Temporary Internet Files. If you have something that alerts you to
> > changes
> > > there, the add-in retrieval of web pages will trigger those alerts...
> > >
> > > I'm assuming you don't use IE as a browser, or I'd think you should be
> > > getting such alerts all the time.
> > >
> >
>

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

Re: Please help: keep getting windows security alarm

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

Wed Sep 28, 2011 3:38 pm (PDT)



Right. Settings and files.

On Wed, Sep 28, 2011 at 3:35 PM, xjiaan <xjiaan@yahoo.com> wrote:

>
> so i need change the security setting of IE ,because EXCEL use the same
> configuration as IE ?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2g.

Re: Please help: keep getting windows security alarm

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

Wed Sep 28, 2011 3:41 pm (PDT)



ok,i will try to lower the internet security seting to see whether this can help.

very appreciate your help!

have a good night!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Right. Settings and files.
>
> On Wed, Sep 28, 2011 at 3:35 PM, xjiaan <xjiaan@...> wrote:
>
> >
> > so i need change the security setting of IE ,because EXCEL use the same
> > configuration as IE ?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need traffic?

Drive customers

With search ads

on Yahoo!

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
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 03.00

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)