5 Messages
Digest #3964
Messages
Thu Apr 13, 2017 7:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo is now building many web pages from JSON data, so the tables no
longer exist in the source code of their web pages. So many old extractions
are failing.
Unfortunately, I have no access to EXCEL in the near future...?
Why not just get data items "j" and "k" with RCHGetYahooQuotes()?
On Thu, Apr 13, 2017 at 7:08 PM, sjagers@ wrote:
>
> I tried to use GetElements 975 (52-Week High) and 976 (52-Week Low) today,
> but they're returning an Error.
> They worked last Friday, but not today. Did Yahoo change their Key Stats
> page?
> FYI.
>
longer exist in the source code of their web pages. So many old extractions
are failing.
Unfortunately, I have no access to EXCEL in the near future...?
Why not just get data items "j" and "k" with RCHGetYahooQuotes(
On Thu, Apr 13, 2017 at 7:08 PM, sjagers@ wrote:
>
> I tried to use GetElements 975 (52-Week High) and 976 (52-Week Low) today,
> but they're returning an Error.
> They worked last Friday, but not today. Did Yahoo change their Key Stats
> page?
> FYI.
>
Fri Apr 14, 2017 8:45 am (PDT) . Posted by:
nelsonmuntz1000
I set Excel Options Formulas for Manual Recalculation, no recalculate before saving, enable iterative calculation. Select your cells, right click, select Randy's SMF option at the bottom of the dialogue box and select Recalculate selection.
I really like this feature, it works really well for any Excel formula. Randy, is it possible to get this option into my Quick Access Toolbar? It's not listed with the other macros. Thanks
I really like this feature, it works really well for any Excel formula. Randy, is it possible to get this option into my Quick Access Toolbar? It's not listed with the other macros. Thanks
Fri Apr 14, 2017 10:19 am (PDT) . Posted by:
john_hoel
I use this feature very frequently. Thanks Randy, really useful.
Fri Apr 14, 2017 10:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You should be able to set up a QAT button for the macro, but I don't have
access to EXCEL for the next few weeks, so can't give you the details of
the macro itself.
I don't find "Recalculate selection" to be of much use for the add-in. For
a formula that is pulling data from a web page, it doesn't do you any good
to recalculate, because it would just come up with the same value because
it is extracting data from a saved copy of the web page. In order to get a
fresh copy of the web page from the Internet, you need to use
smfForceRecalculation, which requires a full recalculation of all open
workbooks.
On Fri, Apr 14, 2017 at 8:45 AM, ccoupe300@
...wrote:
>
> I set Excel Options Formulas for Manual Recalculation, no recalculate
> before saving, enable iterative calculation. Select your cells, right
> click, select Randy's SMF option at the bottom of the dialogue box and
> select Recalculate selection.
>
> I really like this feature, it works really well for any Excel formula.
> Randy, is it possible to get this option into my Quick Access Toolbar? It's
> not listed with the other macros. Thanks
>
access to EXCEL for the next few weeks, so can't give you the details of
the macro itself.
I don't find "Recalculate selection" to be of much use for the add-in. For
a formula that is pulling data from a web page, it doesn't do you any good
to recalculate, because it would just come up with the same value because
it is extracting data from a saved copy of the web page. In order to get a
fresh copy of the web page from the Internet, you need to use
smfForceRecalculati
workbooks.
On Fri, Apr 14, 2017 at 8:45 AM, ccoupe300@
...wrote:
>
> I set Excel Options Formulas for Manual Recalculation, no recalculate
> before saving, enable iterative calculation. Select your cells, right
> click, select Randy's SMF option at the bottom of the dialogue box and
> select Recalculate selection.
>
> I really like this feature, it works really well for any Excel formula.
> Randy, is it possible to get this option into my Quick Access Toolbar? It's
> not listed with the other macros. Thanks
>
Fri Apr 14, 2017 10:52 am (PDT) . Posted by:
john_hoel
Randy,
I have written a number of VBA functions that recalculate with your wonderful 'recalculate selection' feature. I use it a LOT!
I have written a number of VBA functions that recalculate with your wonderful 'recalculate selection' feature. I use it a LOT!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar