5 Messages
Digest #4420
Messages
Sun Nov 11, 2018 6:35 am (PST) . Posted by:
"The Kuffels" kuffel
Randy,
<< message you're getting sounds like a workbook is being opened from when you had the add-in in a different location >>
Don't think so. The message comes up instantly when Excel is opened. No workbook is yet accessed. The message is referring to the prior version of SMF which I moved from c:\SMF Add-In. All the "Link" entries I can find refer to the current version in C:\SMF Add-In.
<< running the smfFixLinks macro from the add-in will fix such unresolved links >>
Can't find any documentation on how to run SMFFixLinks. Assume it is the Fix Links option on the SMF option on the Context Menu. Doesn't help.
Current situation:
Installed SMF on my wife's new machine, which has never had SMF before.
=SMFGetYahooPortfolioView(A5,"15") gets the price with the ticker in cell A5. Right Click on the price cell brings up a menu, but there is no entry for SMF, so there is no access to the recalculation macro.
On the old machine, go to a new Excel workbook where "Version" querry works. But PortfolioView does not work. But Right Click brings up a context menu with SMF options. With the original workbook was able to change link to new location but still no price.
Any other ideas? Using my wife's computer would be a viable work around but then I really need some way to recalculate prices every half-hour or so.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
<< message you're getting sounds like a workbook is being opened from when you had the add-in in a different location >>
Don't think so. The message comes up instantly when Excel is opened. No workbook is yet accessed. The message is referring to the prior version of SMF which I moved from c:\SMF Add-In. All the "Link" entries I can find refer to the current version in C:\SMF Add-In.
<< running the smfFixLinks macro from the add-in will fix such unresolved links >>
Can't find any documentation on how to run SMFFixLinks. Assume it is the Fix Links option on the SMF option on the Context Menu. Doesn't help.
Current situation:
Installed SMF on my wife's new machine, which has never had SMF before.
=SMFGetYahooPortfolioView(A5,"15") gets the price with the ticker in cell A5. Right Click on the price cell brings up a menu, but there is no entry for SMF, so there is no access to the recalculation macro.
On the old machine, go to a new Excel workbook where "Version" querry works. But PortfolioView does not work. But Right Click brings up a context menu with SMF options. With the original workbook was able to change link to new location but still no price.
Any other ideas? Using my wife's computer would be a viable work around but then I really need some way to recalculate prices every half-hour or so.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Sun Nov 11, 2018 8:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
If you're getting the message when you simply open EXCEL, you probably
still have something in the add-in manager referring to the add-in in that
location? EXCEL tries to load all add-ins when first opened. If that's the
case, it may explain all the problems? Hopefully?
To manually run smfFixLinks, you can hit alt+F8 to bring up the macro
dialog, type in the name, and then click on "Run" when it becomes active. I
have it assigned to a button on my Quick Access Toolbar. You can similarly
run the smfForceRecalculation macro.
When you open a new workbook on your computer and do the "Version" function
successfully, the stand-alone smfGetYahooPortfolioView() function didn't
work either?
=SMFGetYahooPortfolioView("MMM","15")
Not sure why the context menu isn't available on your wife's computer.
That's been an issue for some people in the past, but seemed to be related
to people having other add-ins installed? There may be something
interfering with the start-up events within EXCEL that load the context
menu, but without experiencing the issue first-hand, that's only a guess.
If the above function usage doesn't work, try this:
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
")
That's the URL used to get just the price data from Yahoo, in JSON format.
It should look something like this:
{"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","regularMarketPrice":201.1,"regularMarketTime":1541797313,"marketState";:"CLOSED","market":"us_market","esgPopulated":false,"tradeable":true,"fullExchangeName":"NYSE","exchange":"NYQ","sourceInterval":15,"exchangeTimezoneName":"America/New_York","exchangeTimezoneShortName":"EST","gmtOffSetMilliseconds":-18000000,"exchangeDataDelayedBy";:0,"symbol":"MMM"}],"error":null}}
On Sun, Nov 11, 2018 at 7:36 AM 'The Kuffels' kuffel@... wrote:
>
> << message you're getting sounds like a workbook is being opened from
> when you had the add-in in a different location >>
>
> Don't think so. The message comes up *instantly* when Excel is opened.
> No workbook is yet accessed. The message is referring to the prior version
> of SMF which I moved from c:\SMF Add-In. All the "Link" entries I can find
> refer to the current version in C:\SMF Add-In.
>
> << running the smfFixLinks macro from the add-in will fix such
> unresolved links >>
>
> Can't find any documentation on how to run SMFFixLinks. Assume it is the
> Fix Links option on the SMF option on the Context Menu. Doesn't help.
>
> Current situation:
>
> Installed SMF on my wife's new machine, which has never had SMF before.
> =SMFGetYahooPortfolioView(A5,"15") gets the price with the ticker in
> cell A5. Right Click on the price cell brings up a menu, but there is no
> entry for SMF, so there is no access to the recalculation macro.
>
> On the old machine, go to a new Excel workbook where "Version" querry
> works. But PortfolioView does not work. But Right Click brings up a
> context menu with SMF options. With the original workbook was able to
> change link to new location but still no price.
>
> Any other ideas? Using my wife's computer would be a viable work around
> but then I really need some way to recalculate prices every half-hour or so.
>
still have something in the add-in manager referring to the add-in in that
location? EXCEL tries to load all add-ins when first opened. If that's the
case, it may explain all the problems? Hopefully?
To manually run smfFixLinks, you can hit alt+F8 to bring up the macro
dialog, type in the name, and then click on "Run" when it becomes active. I
have it assigned to a button on my Quick Access Toolbar. You can similarly
run the smfForceRecalculation macro.
When you open a new workbook on your computer and do the "Version" function
successfully, the stand-alone smfGetYahooPortfolioView() function didn't
work either?
=SMFGetYahooPortfolioView("MMM","15")
Not sure why the context menu isn't available on your wife's computer.
That's been an issue for some people in the past, but seemed to be related
to people having other add-ins installed? There may be something
interfering with the start-up events within EXCEL that load the context
menu, but without experiencing the issue first-hand, that's only a guess.
If the above function usage doesn't work, try this:
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
")
That's the URL used to get just the price data from Yahoo, in JSON format.
It should look something like this:
{"quoteRespons
On Sun, Nov 11, 2018 at 7:36 AM 'The Kuffels' kuffel@... wrote:
>
> << message you're getting sounds like a workbook is being opened from
> when you had the add-in in a different location >>
>
> Don't think so. The message comes up *instantly* when Excel is opened.
> No workbook is yet accessed. The message is referring to the prior version
> of SMF which I moved from c:\SMF Add-In. All the "Link" entries I can find
> refer to the current version in C:\SMF Add-In.
>
> << running the smfFixLinks macro from the add-in will fix such
> unresolved links >>
>
> Can't find any documentation on how to run SMFFixLinks. Assume it is the
> Fix Links option on the SMF option on the Context Menu. Doesn't help.
>
> Current situation:
>
> Installed SMF on my wife's new machine, which has never had SMF before.
> =SMFGetYahooPortfol
> cell A5. Right Click on the price cell brings up a menu, but there is no
> entry for SMF, so there is no access to the recalculation macro.
>
> On the old machine, go to a new Excel workbook where "Version" querry
> works. But PortfolioView does not work. But Right Click brings up a
> context menu with SMF options. With the original workbook was able to
> change link to new location but still no price.
>
> Any other ideas? Using my wife's computer would be a viable work around
> but then I really need some way to recalculate prices every half-hour or so.
>
Sun Nov 11, 2018 7:51 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, not a clue. I know there's been talk of using another programming
language, but I doubt they would simply drop VBA. But they may have
changed the way they handle add-ins...
On Sun, Nov 11, 2018 at 6:24 AM Darryl Bonfessuto dmb7111@... wrote:
>
> Is the add-in compatibles in excel 2019?
>
>
>
language, but I doubt they would simply drop VBA. But they may have
changed the way they handle add-ins...
On Sun, Nov 11, 2018 at 6:24 AM Darryl Bonfessuto dmb7111@... wrote:
>
> Is the add-in compatibles in excel 2019?
>
>
>
Sun Nov 11, 2018 11:18 am (PST) . Posted by:
"The Kuffels" kuffel
Now working, Path:
New computer test workbook kept changing from value to #NAME. Reloading the SMF via the Add-In Manager and each time the data was restored. After a few cycles of this, data remained and Context menu had the SMF option.
Now for really weird. Copied the complex worksheet from the old machine to the new. After changing the Add-in calls to GetYahooPortfolioView it worked perfectly except a blank symbol produced an error message instead of a null value.
So all is working satisfactorily but I have no idea why.
Thanks for the hand holding.
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
New computer test workbook kept changing from value to #NAME. Reloading the SMF via the Add-In Manager and each time the data was restored. After a few cycles of this, data remained and Context menu had the SMF option.
Now for really weird. Copied the complex worksheet from the old machine to the new. After changing the Add-in calls to GetYahooPortfolioView it worked perfectly except a blank symbol produced an error message instead of a null value.
So all is working satisfactorily but I have no idea why.
Thanks for the hand holding.
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Sun Nov 11, 2018 12:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The need to reload may be an issue that first occurred in July of 2016
because MicroSoft issued some security updates. It prevents EXCEL from
loading "downloaded" add-ins when EXCEL starts up.
For a workaround suggested by Microsoft, until they supposedly fix the
issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I've never run into the issue myself, but I've always had Windows 10 on
this machine. Don't know if that makes a difference.
On Sun, Nov 11, 2018 at 12:18 PM 'The Kuffels' kuffel@... wrote:
>
> Now working, Path:
>
> New computer test workbook kept changing from value to #NAME. Reloading
> the SMF via the Add-In Manager and each time the data was restored. After
> a few cycles of this, data remained and Context menu had the SMF option.
>
> Now for really weird. Copied the complex worksheet from the old machine
> to the new. After changing the Add-in calls to GetYahooPortfolioView it
> worked perfectly except a blank symbol produced an error message instead of
> a null value.
>
> So all is working satisfactorily but I have no idea why.
>
> Thanks for the hand holding.
>
>
>
because MicroSoft issued some security updates. It prevents EXCEL from
loading "downloaded" add-ins when EXCEL starts up.
For a workaround suggested by Microsoft, until they supposedly fix the
issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I've never run into the issue myself, but I've always had Windows 10 on
this machine. Don't know if that makes a difference.
On Sun, Nov 11, 2018 at 12:18 PM 'The Kuffels' kuffel@... wrote:
>
> Now working, Path:
>
> New computer test workbook kept changing from value to #NAME. Reloading
> the SMF via the Add-In Manager and each time the data was restored. After
> a few cycles of this, data remained and Context menu had the SMF option.
>
> Now for really weird. Copied the complex worksheet from the old machine
> to the new. After changing the Add-in calls to GetYahooPortfolioVi
> worked perfectly except a blank symbol produced an error message instead of
> a null value.
>
> So all is working satisfactorily but I have no idea why.
>
> Thanks for the hand holding.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar