Sabtu, 17 Oktober 2015

[smf_addin] Digest Number 3535

3 Messages

Digest #3535

Messages

Fri Oct 16, 2015 10:31 am (PDT) . Posted by:

dmatu2000

Does anyone have any template for pulling data for closed ended mutual funds?

Fri Oct 16, 2015 10:50 am (PDT) . Posted by:

weldenc

I have been using RCH_Stock_Market_Functions for 34 or 4 years and I love it. I've recently encountered an issue that very annoying.


I am running Office 365 and store my spreadsheet on OneDrive. I access my spreadsheet from several different computers. I store RCH_Stock_Market_Functions in c:\Programs Files\SMF Add-in on all computers. About half the time when I load the spreadsheet, the path to RCH_Stock_Market_Functions shows as


https://d.docs.live.net/Program Files/SMF Add-in/RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes


Each time I have to edit the array and change it to RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes and it works fine. As I said, this doesn't happen every time. I suspect it happens when I oopen it on a different PC from the previous open.


Has this hapopened to others and is there a way to avoid it? TIA





Fri Oct 16, 2015 11:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The stored path will always be from the machine that the workbook was last
saved on. EXCEL saves a hard-coded location of where the add-in is. If
EXCEL opens the workbook and doesn't find that activated add-in in that
hard-coded location, it flags it as an unresolved link that needs to be
fixed.

It could be you have one (or more) machines that actually have the add-in
activated in a different location (the D: file path), even though you have
a copy of the add-in in the "correct" location. You can double-check that
by checking the version of the add-in, or by using the add-in manager from
within EXCEL.

I have the smfFixLinks macro assigned to a button, so I just run that
whenever I run into unresolved links.

On Fri, Oct 16, 2015 at 10:50 AM, weldencd@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have been using RCH_Stock_Market_Functions for 34 or 4 years and I love
> it. I've recently encountered an issue that very annoying.
> I am running Office 365 and store my spreadsheet on OneDrive. I access my
> spreadsheet from several different computers. I store
> RCH_Stock_Market_Functions in c:\Programs Files\SMF Add-in on all
> computers. About half the time when I load the spreadsheet, the path to
> RCH_Stock_Market_Functions shows as
>
> https://d.docs.live.net/Program Files/SMF
> Add-in/RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes
>
> Each time I have to edit the array and change it to
> RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes and it works fine. As I
> said, this doesn't happen every time. I suspect it happens when I oopen it
> on a different PC from the previous open.
>
> Has this hapopened to others and is there a way to avoid it? TIA
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar