2 Messages
Digest #3923
Messages
Sat Feb 18, 2017 9:03 am (PST) . Posted by:
jeffesch
Randy,
I've been using your add-in for years and I continue to find new ways to use it. Thanks for all the work you put into this.
In a workbook that I've successfully used your add-in, just this week, I'm getting an UNDEFINED result in most of the cells that I'm using the RCHGetElementNumber() function. For instance, =RCHGetElementNumber(A1,13863) which normally provides the stock name. When I use =RCHGetYahooQuotes(A1,"l1"), I'm getting the current price/share as expected. I'm getting a good result when I issue =RCHGetElementNumber("version"). I updated to the most current version of the add-in.
I'm using Windows 7 and Excel 2010. I read some of the comments about the Trust issue, so I added the SMF Add-In folder as a trusted location.
Is there something that I try to get this to work again?
Thanks,
Jeff
I've been using your add-in for years and I continue to find new ways to use it. Thanks for all the work you put into this.
In a workbook that I've successfully used your add-in, just this week, I'm getting an UNDEFINED result in most of the cells that I'm using the RCHGetElementNumber
I'm using Windows 7 and Excel 2010. I read some of the comments about the Trust issue, so I added the SMF Add-In folder as a trusted location.
Is there something that I try to get this to work again?
Thanks,
Jeff
Sat Feb 18, 2017 9:06 am (PST) . Posted by:
"Randy Harmelink" rharmelink
"Undefined" usually means you don't have the element definitions file in
the folder where the add-in resides. Those are the "smf-elements-*.txt"
files. Those contain the element definitions and are loaded when the
RCHGetElementNumber() function is used to get an element for the first time.
On Sat, Feb 18, 2017 at 6:10 AM, jeffesch@
...wrote:
> I've been using your add-in for years and I continue to find new ways to
> use it. Thanks for all the work you put into this.
>
> In a workbook that I've successfully used your add-in, just this week, I'm
> getting an UNDEFINED result in most of the cells that I'm using the
> RCHGetElementNumber() function. For instance,
> =RCHGetElementNumber(A1,13863) which normally provides the stock name.
> When I use =RCHGetYahooQuotes(A1,"l1"), I'm getting the current price/share
> as expected. I'm getting a good result when I issue
> =RCHGetElementNumber("version"). I updated to the most current version
> of the add-in.
>
> I'm using Windows 7 and Excel 2010. I read some of the comments about the
> Trust issue, so I added the SMF Add-In folder as a trusted location.
>
> Is there something that I try to get this to work again?
>
>
the folder where the add-in resides. Those are the "smf-elements-
files. Those contain the element definitions and are loaded when the
RCHGetElementNumber
On Sat, Feb 18, 2017 at 6:10 AM, jeffesch@
...wrote:
> I've been using your add-in for years and I continue to find new ways to
> use it. Thanks for all the work you put into this.
>
> In a workbook that I've successfully used your add-in, just this week, I'm
> getting an UNDEFINED result in most of the cells that I'm using the
> RCHGetElementNumber
> =RCHGetElementNumbe
> When I use =RCHGetYahooQuotes(
> as expected. I'm getting a good result when I issue
> =RCHGetElementNumbe
> of the add-in.
>
> I'm using Windows 7 and Excel 2010. I read some of the comments about the
> Trust issue, so I added the SMF Add-In folder as a trusted location.
>
> Is there something that I try to get this to work again?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar