3 New Messages
Digest #2384
Messages
Thu Oct 25, 2012 6:14 am (PDT) . Posted by:
"twopourdrummer" twopourdrummer
I don't think it's the code. The #value can mean that the data doesn't match the format, meaning that the text being pulled down doesn't match the number format. I can use the same URL and change the parameter to pull a number and it works. There must be a global Excel setting that doesn't like it pulling text data.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. The first and third time out on me, both in EXCEL and in FireFox. The
> second one works fine.
>
> I can't think of any reason why these would return with a #VALUE! error.
>
> On Wed, Oct 24, 2012 at 6:55 AM, twopourdrummer <twopourdrummer@...>wrote:
>
> > Sure
> >
> > RCHGetTableCell("
> > http://www.smartmoney.com/eqsnaps/index.cfm?story=competition&symbol=msft,
> > 3,">Competitive Analysis")
> >
> >
> > RCHGetTableCell("http://www.smartmoney.com/quote/msft/?story=profile
> > ",1,"Address")
> >
> > RCHGetTableCell("
> > http://www.zacks.com/research/report.php?type=report&t=msft ",1,"Sector:")
> >
> > Note, I replaced my stock variable with msft. It would normally be
> > something like "&B1&". Also note, that the references do work on my home
> > computer and use to work on my work computer, so I know I'm not passing an
> > improper parameter.
> >
>
--- In smf_addin@yahoogrou
>
> Hmmm. The first and third time out on me, both in EXCEL and in FireFox. The
> second one works fine.
>
> I can't think of any reason why these would return with a #VALUE! error.
>
> On Wed, Oct 24, 2012 at 6:55 AM, twopourdrummer <twopourdrummer@
>
> > Sure
> >
> > RCHGetTableCell(
> > http://www.smartmon
> > 3,">Competitive Analysis")
> >
> >
> > RCHGetTableCell(
> > ",1,"Address"
> >
> > RCHGetTableCell(
> > http://www.zacks.
> >
> > Note, I replaced my stock variable with msft. It would normally be
> > something like "&B1&". Also note, that the references do work on my home
> > computer and use to work on my work computer, so I know I'm not passing an
> > improper parameter.
> >
>
Thu Oct 25, 2012 6:25 am (PDT) . Posted by:
"Ron Daring" ritchierun
I am using Windows 7 64-bit, and the files seem to work fine.
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, October 24, 2012 10:02 PM
Subject: Re: [smf_addin] smf addin Feb 2012
As far as I know, it does, but I have no personal experience with it...
On Wed, Oct 24, 2012 at 9:20 PM, R <venkat1926@yahoo.com > wrote:
I have donwlaoded the files given under
> RCH_Stock_Market_Functions-2.1.2012.02.02.zip
>
>will this work in windows 7.
>
>I had similar files when I had windows xp and it worked but whenI shifted to windows 7 these addin did not work. that is why the query.
>
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Wednesday, October 24, 2012 10:02 PM
Subject: Re: [smf_addin] smf addin Feb 2012
As far as I know, it does, but I have no personal experience with it...
On Wed, Oct 24, 2012 at 9:20 PM, R <venkat1926@yahoo.
I have donwlaoded the files given under
> RCH_Stock_Market_
>
>will this work in windows 7.
>
>I had similar files when I had windows xp and it worked but whenI shifted to windows 7 these addin did not work. that is why the query.
>
Thu Oct 25, 2012 11:41 am (PDT) . Posted by:
"David Nicholson" djsnicholson
I just initiated a new computer with Windows 7, and downloaded the files
and got the SMF routines to work after I "installed" the add-in into my
excel spreadsheet. Hence the problem is not WIN 7.
On Thu, Oct 25, 2012 at 12:20 AM, R <venkat1926@yahoo.com > wrote:
> **
>
>
> I have donwlaoded the files given under
> RCH_Stock_Market_Functions-2.1.2012.02.02.zip
>
> will this work in windows 7.
>
> I had similar files when I had windows xp and it worked but whenI shifted
> to windows 7 these addin did not work. that is why the query.
>
> thanks.
>
>
>
and got the SMF routines to work after I "installed" the add-in into my
excel spreadsheet. Hence the problem is not WIN 7.
On Thu, Oct 25, 2012 at 12:20 AM, R <venkat1926@yahoo.
> **
>
>
> I have donwlaoded the files given under
> RCH_Stock_Market_
>
> will this work in windows 7.
>
> I had similar files when I had windows xp and it worked but whenI shifted
> to windows 7 these addin did not work. that is why the query.
>
> thanks.
>
>
>
Tidak ada komentar:
Posting Komentar