Jumat, 11 Mei 2012

[smf_addin] Digest Number 2208

Messages In This Digest (9 Messages)

Messages

1a.

Re: two RCHGetElementNumber calls return "Error" message

Posted by: "Ping Zhu" p_zhu00@yahoo.com   p_zhu00

Thu May 10, 2012 5:03 pm (PDT)



Thanks Randy. I copied your new  smf-elements-1.txt file from "Works in
Progress" folder, and replaced it with the one that's under "C:\Program
Files\SMF Add-In\". However, when I ran this model, RCHGetElementNumber(Ticker,
1) still returns "Error". I suspect that it's because Excel is referring to the
add in file at some other locations (I used to get the add in from a different
folder). Is there a way to completely unload "SMF Add-In" and then reload it?

Thanks and regards,
Ping

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thu, May 10, 2012 9:23:42 AM
Subject: Re: [smf_addin] two RCHGetElementNumber calls return "Error" message

 
You probably just need the new smf-elements-1.txt file from the "Works in
Progress" folder. It has the latest element definitions for MSN elements.

On Thu, May 10, 2012 at 9:05 AM, Ping Zhu <p_zhu00@yahoo.com> wrote:

>
>The following 2 functions are returning "Error" for me, either with the latest
>SMF AddIn files (updated in February 2012).
>
>Ticker = "IBM"
>RCHGetElementNumber(Ticker, 1)
>RCHGetElementNumber(Ticker, 13862) 
>
>The other RCHGetElementNumber calls all work for me.
>
>Can someone tell me how to solve this issue?
>

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

Re: two RCHGetElementNumber calls return "Error" message

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

Thu May 10, 2012 5:17 pm (PDT)



Exit and restart EXCEL.

On Thu, May 10, 2012 at 5:03 PM, Ping Zhu <p_zhu00@yahoo.com> wrote:

>
> Is there a way to completely unload "SMF Add-In" and then reload it?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Re: Only #Value! cells, no data!

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

Thu May 10, 2012 5:16 pm (PDT)



Check out the "Location errors" entry in the "Links" area of the Yahoo
group.

I stopped using the "Edit Links" option in EXCEL to fix unresolved links,
because it never seemed to work quite right. You need to manually edit
things to resolve links. Or, try running the smfFixLinks macro. I use it
whenever I need to fix unresolved links.

The quickest way to see if the add-in is installed:

=RCHGetElementNumber("Version")

On Thu, May 10, 2012 at 4:27 PM, mutantcar <mutant.car@virgin.net> wrote:

> You're correct I'm sure Randy. As I said, I'm using a slightly modified
> version, and I don't think I've added it correctly as an Add In. I'll take
> a look sometime.
>
> It's been working fine, but since Windows update, it appears I need to
> Edit links, Open source, and Enable Macros in an Excel Security notice
> popup.
>
> Maybe the OP hasn't correctly added the Add In?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3a.

explanation requested on cookies, IE9, Excel, Firefox and IBD

Posted by: "mff2805" mff3429@comcast.net   mff2805

Fri May 11, 2012 12:07 am (PDT)



hi,
i use the ibd stock checkup template many times a week, and in a variety of ways. i've seen that if i have an ibd stock checkup webpage open in firefox, then log in to an ibd webpage with ie9, then my firefox login gets cancelled. i don;t like that behavior, but that's the way it is - ibd's way of enforcing only on user per paid account.

my difficulty is that sometimes the ibd checkup template can return all errors; my understanding is that to restore functionality to the excel template, i need to login to ibd via ie9 so that an appropriate cookie gets stored on my computer. but doing so doesn't always seem to work. i've also notices at times that i can be logged in to ibd using firefox, can type a new ticker in the excel template, get results in the template, yet stay logged in my firefox ibd session.
so, i don;t quite understand what's going on an am looking for an explanation.
regarding cookies, is there a firefox ibd cookie stored where firefox puts cookies and an ie9 ibd cookie where ie puts cookies. does the firefox ibd cookie get deleted when i log in to ibd using ie9? can i save master copies of each cookie in say my documents folder and then copy the appropriate one back to the magic location when i want to use either ibd with either firefox or ie9/excel?
i'm willing to put up with some minor annoyances/gyrations in order to continue 1. using firefox as my web browser and 2. using the ibd stock checkup template.
i suspect the same behavior would apply if google chrome was my default browser, right?
thanks much,
mike

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

Re: explanation requested on cookies, IE9, Excel, Firefox and IBD

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

Fri May 11, 2012 12:24 am (PDT)



Google Chrome and FireFox cookies would be irrelevant. But, yes, they have
separate cookies from IE.

Because IE and EXCEL are both Microsoft products, they use the same
Internet engine. And the add-in uses the Microsoft Internet Engine to
access the Internet. That's why the IE cookies, settings, and Temporary
Internet Files are all tied in to the add-in's usage of the Internet.

I, too, have been a little peeved that when I log into IBD with FireFox, it
typically logs me out of my IE session (and vice versa). I'm not sure why
they should care that I'm using two different browsers to access their
site. But, as you note, it's probably the way they've decided to make sure
the account is only being used by a single user.

But I have no idea why sometimes both FireFox and IE seem to be working at
the same time. It happens so infrequently, and I don't really use it all
that often, so I haven't seen any pattern. It may have something to do with
whether the IE used by EXCEL is the same IE used as a browser -- I'm not
sure both always get updated to the same version.

You might be able to "fake it" by copying files, which might work for a
short time. I guess it depend on how much of a bother it is to log in each
way. Another option would be to automate the login with VBA within EXCEL,
but using the IE object.

On Fri, May 11, 2012 at 12:07 AM, mff2805 <mff3429@comcast.net> wrote:

> hi,
> i use the ibd stock checkup template many times a week, and in a variety
> of ways. i've seen that if i have an ibd stock checkup webpage open in
> firefox, then log in to an ibd webpage with ie9, then my firefox login gets
> cancelled. i don;t like that behavior, but that's the way it is - ibd's
> way of enforcing only on user per paid account.
>
> my difficulty is that sometimes the ibd checkup template can return all
> errors; my understanding is that to restore functionality to the excel
> template, i need to login to ibd via ie9 so that an appropriate cookie gets
> stored on my computer. but doing so doesn't always seem to work. i've
> also notices at times that i can be logged in to ibd using firefox, can
> type a new ticker in the excel template, get results in the template, yet
> stay logged in my firefox ibd session.
> so, i don;t quite understand what's going on an am looking for an
> explanation.
> regarding cookies, is there a firefox ibd cookie stored where firefox puts
> cookies and an ie9 ibd cookie where ie puts cookies. does the firefox ibd
> cookie get deleted when i log in to ibd using ie9? can i save master
> copies of each cookie in say my documents folder and then copy the
> appropriate one back to the magic location when i want to use either ibd
> with either firefox or ie9/excel?
> i'm willing to put up with some minor annoyances/gyrations in order to
> continue 1. using firefox as my web browser and 2. using the ibd stock
> checkup template.
> i suspect the same behavior would apply if google chrome was my default
> browser, right?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3c.

Re: explanation requested on cookies, IE9, Excel, Firefox and IBD

Posted by: "mff2805" mff3429@comcast.net   mff2805

Fri May 11, 2012 12:24 am (PDT)



an additional item i don;t understand:
1. i was logged in to ibd via ie9. firefox was not open.
2. inside excel with the stock template open as one of the sheets in the xls file, i did a 'get external data', 'from web', typed investors.com and logged in. then i close that window. i typed in one ticker and got results in the tempplate. then i typed in a different valid ticker and got all errors.
3. doing this logged me off my ie9/ibd session.

still confused........

--- In smf_addin@yahoogroups.com, "mff2805" <mff3429@...> wrote:
>
> hi,
> i use the ibd stock checkup template many times a week, and in a variety of ways. i've seen that if i have an ibd stock checkup webpage open in firefox, then log in to an ibd webpage with ie9, then my firefox login gets cancelled. i don;t like that behavior, but that's the way it is - ibd's way of enforcing only on user per paid account.
>
> my difficulty is that sometimes the ibd checkup template can return all errors; my understanding is that to restore functionality to the excel template, i need to login to ibd via ie9 so that an appropriate cookie gets stored on my computer. but doing so doesn't always seem to work. i've also notices at times that i can be logged in to ibd using firefox, can type a new ticker in the excel template, get results in the template, yet stay logged in my firefox ibd session.
> so, i don;t quite understand what's going on an am looking for an explanation.
> regarding cookies, is there a firefox ibd cookie stored where firefox puts cookies and an ie9 ibd cookie where ie puts cookies. does the firefox ibd cookie get deleted when i log in to ibd using ie9? can i save master copies of each cookie in say my documents folder and then copy the appropriate one back to the magic location when i want to use either ibd with either firefox or ie9/excel?
> i'm willing to put up with some minor annoyances/gyrations in order to continue 1. using firefox as my web browser and 2. using the ibd stock checkup template.
> i suspect the same behavior would apply if google chrome was my default browser, right?
> thanks much,
> mike
>

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

Re: explanation requested on cookies, IE9, Excel, Firefox and IBD

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

Fri May 11, 2012 12:28 am (PDT)



I can't explain (2), but (3) might be the issue I mentioned -- that the IE
used by "Get External Data" isn't IE 9, so it looks to IBD like two
different browsers.

I'm not sure how they get out of sync, but I have had several people note
that logging in with the EXCEL Web Query works and logging in with their IE
browser doesn't. I'm only suspecting that they are two separate versions of
IE when such a situation occurs.

On Fri, May 11, 2012 at 12:24 AM, mff2805 <mff3429@comcast.net> wrote:

> an additional item i don;t understand:
> 1. i was logged in to ibd via ie9. firefox was not open.
> 2. inside excel with the stock template open as one of the sheets in the
> xls file, i did a 'get external data', 'from web', typed investors.comand logged in. then i close that window. i typed in one ticker and got
> results in the tempplate. then i typed in a different valid ticker and got
> all errors.
> 3. doing this logged me off my ie9/ibd session.
>
> still confused........
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3e.

Re: explanation requested on cookies, IE9, Excel, Firefox and IBD

Posted by: "mff2805" mff3429@comcast.net   mff2805

Fri May 11, 2012 12:31 am (PDT)



thanks for the comments.
regarding 'Another option would be to automate the login with VBA within EXCEL, but using the IE object.', how would i go about doing that. do you have examples? i'd be fine with an auto-run-on-open macro in the ibd template file that did an ibd login.
if it logged on my firefox ibd session, oh well.
thanks,
mike

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Google Chrome and FireFox cookies would be irrelevant. But, yes, they have
> separate cookies from IE.
>
> Because IE and EXCEL are both Microsoft products, they use the same
> Internet engine. And the add-in uses the Microsoft Internet Engine to
> access the Internet. That's why the IE cookies, settings, and Temporary
> Internet Files are all tied in to the add-in's usage of the Internet.
>
> I, too, have been a little peeved that when I log into IBD with FireFox, it
> typically logs me out of my IE session (and vice versa). I'm not sure why
> they should care that I'm using two different browsers to access their
> site. But, as you note, it's probably the way they've decided to make sure
> the account is only being used by a single user.
>
> But I have no idea why sometimes both FireFox and IE seem to be working at
> the same time. It happens so infrequently, and I don't really use it all
> that often, so I haven't seen any pattern. It may have something to do with
> whether the IE used by EXCEL is the same IE used as a browser -- I'm not
> sure both always get updated to the same version.
>
> You might be able to "fake it" by copying files, which might work for a
> short time. I guess it depend on how much of a bother it is to log in each
> way. Another option would be to automate the login with VBA within EXCEL,
> but using the IE object.
>
> On Fri, May 11, 2012 at 12:07 AM, mff2805 <mff3429@...> wrote:
>
> > hi,
> > i use the ibd stock checkup template many times a week, and in a variety
> > of ways. i've seen that if i have an ibd stock checkup webpage open in
> > firefox, then log in to an ibd webpage with ie9, then my firefox login gets
> > cancelled. i don;t like that behavior, but that's the way it is - ibd's
> > way of enforcing only on user per paid account.
> >
> > my difficulty is that sometimes the ibd checkup template can return all
> > errors; my understanding is that to restore functionality to the excel
> > template, i need to login to ibd via ie9 so that an appropriate cookie gets
> > stored on my computer. but doing so doesn't always seem to work. i've
> > also notices at times that i can be logged in to ibd using firefox, can
> > type a new ticker in the excel template, get results in the template, yet
> > stay logged in my firefox ibd session.
> > so, i don;t quite understand what's going on an am looking for an
> > explanation.
> > regarding cookies, is there a firefox ibd cookie stored where firefox puts
> > cookies and an ie9 ibd cookie where ie puts cookies. does the firefox ibd
> > cookie get deleted when i log in to ibd using ie9? can i save master
> > copies of each cookie in say my documents folder and then copy the
> > appropriate one back to the magic location when i want to use either ibd
> > with either firefox or ie9/excel?
> > i'm willing to put up with some minor annoyances/gyrations in order to
> > continue 1. using firefox as my web browser and 2. using the ibd stock
> > checkup template.
> > i suspect the same behavior would apply if google chrome was my default
> > browser, right?
> >
>

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

Re: explanation requested on cookies, IE9, Excel, Firefox and IBD

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

Fri May 11, 2012 12:39 am (PDT)



You should be able to find plenty of examples using Google. One example,
something like:

http://www.mrexcel.com/forum/showthread.php?t=449429

On Fri, May 11, 2012 at 12:31 AM, mff2805 <mff3429@comcast.net> wrote:

> regarding 'Another option would be to automate the login with VBA within
> EXCEL, but using the IE object.', how would i go about doing that. do you
> have examples? i'd be fine with an auto-run-on-open macro in the ibd
> template file that did an ibd login.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

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.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)