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
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_
Each time I have to edit the array and change it to RCH_Stock_Market_
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
>
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_
>
> Each time I have to edit the array and change it to
> RCH_Stock_Market_
> 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:
Posting Komentar