[smf_addin] Digest Number 3749

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3749

1a

Re: RCHGetYahooQuotes stops working - here's a workaround by jkslindsay

1b

Re: RCHGetYahooQuotes stops working - here's a workaround by bobc94595

1c

Re: RCHGetYahooQuotes stops working - here's a workaround by "Randy Harmelink" rharmelink

Messages

1a

Re: RCHGetYahooQuotes stops working - here's a workaround

Tue Jul 19, 2016 6:02 am (PDT) . Posted by:

jkslindsay

I have some other VB macros - including a very useful search & replace across all files in a directory - and that gets auto-stored under Windows 10 / Excel 2010 Pro in the following location:

C:\Users\,my user name.\AppData\Roaming\Microsoft\AddIns

I copied all the SMF files to that location, made sure it active in Excel Addins (checked the item that immediately appeared in the list) and it now seems to work.

I love it when the plot thins...

Thanks Randy et al!

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

1b

Re: RCHGetYahooQuotes stops working - here's a workaround

Tue Jul 19, 2016 8:55 pm (PDT) . Posted by:

bobc94595

Here's an interesting YouTube link ( Use smfFixLinks to fix the addin location for SMF files https://www.youtube.com/watch?v=N3zQQuo3AQ8 )


https://www.youtube.com/watch?v=N3zQQuo3AQ8

Use smfFixLinks to fix the addin location for SMF files https://www.youtube.com/watch?v=N3zQQuo3AQ8 Shows how to install smfFixLinks in the quick access toolbar in excel 2010 so hard coded addresses can be easily removed from downloaded smf templates.



View on www.youtube.com https://www.youtube.com/watch?v=N3zQQuo3AQ8
Preview by Yahoo



which I followed, and each file that I open now, I use either the smfFIXLINKS button, or the SMFforcerecalcalculation button, both of which can be set up following the video.

I'm not sure which button causes the correction, but each file I open seems to respond to these buttons. I'm not a techie, but it works for me. I'm not sure how to do a wholesale change of all my excel files, but I'll continue with each individually.

Bob

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

1c

Re: RCHGetYahooQuotes stops working - here's a workaround

Tue Jul 19, 2016 9:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The smfFixLinks macro fixes all of the "unresolved" links, by removing the
location of the add-in in front of the function name. This makes EXCEL use
the first version of the function name it can find -- hopefully the one
within the add-in.

I'm not sure you actually NEED to use smfForceRecalculation at that point.
Just modifying all of the formulas like that should force them to
recalculate.

However, smfFixLinks was intended to be a "one time" fix. Because when you
save the workbook, EXCEL should be saving the correct location of the
add-in. It appears something MicroSoft "updated" is forcing EXCEL to mark
all add-in references to be "unresolved" links.

My hope is that it's because the add-in is located in the "Program Files"
folder, so moving it from there MIGHT fix the problem for the future as
well...

But I'm just guessing.

On Tue, Jul 19, 2016 at 8:55 PM, conlonrc@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Here's an interesting YouTube link ( Use smfFixLinks to fix the addin
> location for SMF files <https://www.youtube.com/watch?v=N3zQQuo3AQ8> )
> [image: image] <https://www.youtube.com/watch?v=N3zQQuo3AQ8>
> Use smfFixLinks to fix the addin location for SMF files
> <https://www.youtube.com/watch?v=N3zQQuo3AQ8>
> Shows how to install smfFixLinks in the quick access toolbar in excel 2010
> so hard coded addresses can be easily removed from downloaded smf templates.
> View on www.youtube.com <https://www.youtube.com/watch?v=N3zQQuo3AQ8>
> Preview by Yahoo
>
>
> which I followed, and each file that I open now, I use either the
> smfFIXLINKS button, or the SMFforcerecalcalculation button, both of which
> can be set up following the video.
>
> I'm not sure which button causes the correction, but each file I open
> seems to respond to these buttons. I'm not a techie, but it works for me.
> I'm not sure how to do a wholesale change of all my excel files, but I'll
> continue with each individually.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 10

• Privacy • Unsubscribe • Terms of Use