Selasa, 07 Mei 2019

[smf_addin] Digest Number 4537[1 Attachment]

3 Messages

Digest #4537
1a
Re: Company Name: Element # 13863 ? by "Randy Harmelink" rharmelink
2a
Add-In Version by lewglenn
2b
Re: Add-In Version [1 Attachment] by "Randy Harmelink" rharmelink

Messages

Mon May 6, 2019 10:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Grab the new smf-elements-2.txt
<http://ogres-crypt.com/SMF/Elements/smf-elements-2.txt> file from the
website. I updated it, but never got around to documenting it, because the
smfGetYahooPortfolioView() is a better way to go, since it can get multiple
items for multiple tickers in a single Internet access for all items in a
single array-entered formula.

On Mon, May 6, 2019 at 3:39 AM sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> It's been a while since I used GetElement # 13863 to obtain a company's
> name.
> It appears that number is no longer working. I keep getting an Error.
> Is there an alternative? Thanks.
>
>
>
>

Mon May 6, 2019 4:51 pm (PDT) . Posted by:

lewglenn

I've installed the add-in in C:\Program Files (instead of in C:) and it's been working fine for quite some time, although it's an older version. The one thing that isn't working is the command in my worksheet to identify the version number. I've used:
Range("A71") = RCHGetElementNumber("Version&quot;). This used to work just fine.



But now this returns nothing in element A71. I'd now like to install the latest version of the add-in. Is there any reason I can't continue to leave the add-in in the Program Files folder? Is this the reason the version number is not being returned with the above command?


Thanks.
Attachment(s) from
1 of 1 Photo(s)

Mon May 6, 2019 5:03 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I haven't a clue why your VBA code isn't working.

But you can have the add-in located in multiple locations. It just requires
telling the add-in manager which one to use. I'm not sure what you need to
do on the VBA side -- maybe make sure the reference there is pointing to
which add-in you want to use.

On Mon, May 6, 2019 at 4:52 PM lewglenn@... wrote:

> I've installed the add-in in C:\Program Files (instead of in C:) and it's
> been working fine for quite some time, although it's an older version. The
> one thing that isn't working is the command in my worksheet to identify the
> version number. I've used:
>
> Range("A71") = RCHGetElementNumber("Version&quot;). This used to work just fine.
>
> But now this returns nothing in element A71. I'd now like to install the
> latest version of the add-in. Is there any reason I can't continue to leave
> the add-in in the Program Files folder? Is this the reason the version
> number is not being returned with the above command?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar