8 Messages
Digest #3091
Messages
Thu Jun 12, 2014 5:37 am (PDT) . Posted by:
friedman_steve
been doing some more testing & its working pretty darn well. Thanks again for the fix..... I certainly never could have figured that out.... Genius.
Is there any downside to making the change? Seems to run just as quickly.
Is there any downside to making the change? Seems to run just as quickly.
Thu Jun 12, 2014 5:44 am (PDT) . Posted by:
"andrei radulescu-banu" iubica2
Not a downside - but you have to check in the status bar below right for
when the URLs have completed to load... Because partially loaded data will
be displayed.
Andrei
On Thu, Jun 12, 2014 at 8:37 AM, friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> been doing some more testing & its working pretty darn well.
> Thanks again for the fix..... I certainly never could have figured that
> out.... Genius.
>
> Is there any downside to making the change? Seems to run just as quickly.
>
>
>
--
==================================
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.com, bitdribble.com
==================================
when the URLs have completed to load... Because partially loaded data will
be displayed.
Andrei
On Thu, Jun 12, 2014 at 8:37 AM, friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> been doing some more testing & its working pretty darn well.
> Thanks again for the fix..... I certainly never could have figured that
> out.... Genius.
>
> Is there any downside to making the change? Seems to run just as quickly.
>
>
>
--
============
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.
============
Thu Jun 12, 2014 11:14 am (PDT) . Posted by:
friedman_steve
I seem to have hit one small roadblock (likely easy to fix)....
on one spreadsheet,.... i run a simple macro that copies formula down to many rows.... calculates... and then pastes as values.
Now after making the change above.... it doesn't wait for the calculation to complete before pasting as values.
Is there VBA language to add to the macro to instruct it to wait?
currently have:
'copy formula
Range("bc17").Select
Selection.Copy
'paste formula
Range("bc17").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
'calculate
Range("bc17").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Calculate
[somewhere here>]
'rest of code
on one spreadsheet,
Now after making the change above.... it doesn't wait for the calculation to complete before pasting as values.
Is there VBA language to add to the macro to instruct it to wait?
currently have:
'copy formula
Range("
Selection.Copy
'paste formula
Range("
Range(Selection, Selection.End(
Selection.PasteSpec
SkipBlanks:=
'calculate
Range("
Range(Selection, Selection.End(
Selection.Calculate
[somewhere here>]
'rest of code
Thu Jun 12, 2014 12:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's the whole point of the "DoEvents"; -- to allow events to occur while
it's processing. It surrenders control to the operating system.
You could create a global boolean variable, and have routines that toggle
it between true and false, and then use it as the parameter for the XMLHTTP
routine. Then you could have your routine turn it off, do your processing,
and then turn it back on again.
But this is new territory for me.
On Thu, Jun 12, 2014 at 11:14 AM, friedman_steve@... wrote:
>
> I seem to have hit one small roadblock (likely easy to fix)....
>
> on one spreadsheet,.... i run a simple macro that copies formula down to
> many rows.... calculates... and then pastes as values.
>
> Now after making the change above.... it doesn't wait for the calculation
> to complete before pasting as values.
>
> Is there VBA language to add to the macro to instruct it to wait?
>
> currently have:
>
> 'copy formula
> Range("bc17").Select
> Selection.Copy
> 'paste formula
> Range("bc17").Select
> Range(Selection, Selection.End(xlDown)).Select
> Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
> SkipBlanks:=False, Transpose:=False
>
> 'calculate
> Range("bc17").Select
> Range(Selection, Selection.End(xlDown)).Select
> Selection.Calculate
>
> [somewhere here>]
>
> 'rest of code
>
>
it's processing. It surrenders control to the operating system.
You could create a global boolean variable, and have routines that toggle
it between true and false, and then use it as the parameter for the XMLHTTP
routine. Then you could have your routine turn it off, do your processing,
and then turn it back on again.
But this is new territory for me.
On Thu, Jun 12, 2014 at 11:14 AM, friedman_steve@
>
> I seem to have hit one small roadblock (likely easy to fix)....
>
> on one spreadsheet,
> many rows.... calculates..
>
> Now after making the change above.... it doesn't wait for the calculation
> to complete before pasting as values.
>
> Is there VBA language to add to the macro to instruct it to wait?
>
> currently have:
>
> 'copy formula
> Range("
> Selection.Copy
> 'paste formula
> Range("
> Range(Selection, Selection.End(
> Selection.PasteSpec
> SkipBlanks:=
>
> 'calculate
> Range("
> Range(Selection, Selection.End(
> Selection.Calculate
>
> [somewhere here>]
>
> 'rest of code
>
>
Thu Jun 12, 2014 12:54 pm (PDT) . Posted by:
"andrei radulescu-banu" iubica2
Sorry, fat fingers. They recommend doing
Do Until Application.CalculationState = xlDone
DoEventsLoop
in order to detect whether previous calculations are complete. But I have
not tried this....
Andrei
Do Until Application.
DoEventsLoop
in order to detect whether previous calculations are complete. But I have
not tried this....
Andrei
Thu Jun 12, 2014 12:54 pm (PDT) . Posted by:
"andrei radulescu-banu" iubica2
Is this because you are executing the macro before the computation is
complete? If so, what's needed is a way to detect whether other
calculations are ongoing. Here is a possible idea:
http://stackoverflow.com/questions/8843750/how-do-i-determine-whether-calculation-was-completed-or-detect-interrupted-calc
They recommend doing
Andrei
On Thu, Jun 12, 2014 at 3:06 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> That's the whole point of the "DoEvents"; -- to allow events to occur while
> it's processing. It surrenders control to the operating system.
>
> You could create a global boolean variable, and have routines that toggle
> it between true and false, and then use it as the parameter for the XMLHTTP
> routine. Then you could have your routine turn it off, do your processing,
> and then turn it back on again.
>
> But this is new territory for me.
>
> On Thu, Jun 12, 2014 at 11:14 AM, friedman_steve@... wrote:
>
>>
>> I seem to have hit one small roadblock (likely easy to fix)....
>>
>> on one spreadsheet,.... i run a simple macro that copies formula down to
>> many rows.... calculates... and then pastes as values.
>>
>> Now after making the change above.... it doesn't wait for the calculation
>> to complete before pasting as values.
>>
>> Is there VBA language to add to the macro to instruct it to wait?
>>
>> currently have:
>>
>> 'copy formula
>> Range("bc17").Select
>> Selection.Copy
>> 'paste formula
>> Range("bc17").Select
>> Range(Selection, Selection.End(xlDown)).Select
>> Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
>> SkipBlanks:=False, Transpose:=False
>>
>> 'calculate
>> Range("bc17").Select
>> Range(Selection, Selection.End(xlDown)).Select
>> Selection.Calculate
>>
>> [somewhere here>]
>>
>> 'rest of code
>>
>>
>
>
--
==================================
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.com, bitdribble.com
==================================
complete? If so, what's needed is a way to detect whether other
calculations are ongoing. Here is a possible idea:
http://stackoverflow.com/questions/8843750/how-do-i-determine-whether-calculation-was-completed-or-detect-interrupted-calc
They recommend doing
Andrei
On Thu, Jun 12, 2014 at 3:06 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> That's the whole point of the "DoEvents"
> it's processing. It surrenders control to the operating system.
>
> You could create a global boolean variable, and have routines that toggle
> it between true and false, and then use it as the parameter for the XMLHTTP
> routine. Then you could have your routine turn it off, do your processing,
> and then turn it back on again.
>
> But this is new territory for me.
>
> On Thu, Jun 12, 2014 at 11:14 AM, friedman_steve@
>
>>
>> I seem to have hit one small roadblock (likely easy to fix)....
>>
>> on one spreadsheet,
>> many rows.... calculates..
>>
>> Now after making the change above.... it doesn't wait for the calculation
>> to complete before pasting as values.
>>
>> Is there VBA language to add to the macro to instruct it to wait?
>>
>> currently have:
>>
>> 'copy formula
>> Range("
>> Selection.Copy
>> 'paste formula
>> Range("
>> Range(Selection, Selection.End(
>> Selection.PasteSpec
>> SkipBlanks:=
>>
>> 'calculate
>> Range("
>> Range(Selection, Selection.End(
>> Selection.Calculate
>>
>> [somewhere here>]
>>
>> 'rest of code
>>
>>
>
>
--
============
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.
============
Thu Jun 12, 2014 8:00 am (PDT) . Posted by:
"Andy Yang" acw_yang
Hi
I'm using =RCHGetYahooQuotes("IBE.MC","n") and getting blanks rather than names that I can see on Yahoo Finance. Also for SAN.MC and TEF.MC. Any idea why?
Andy
I'm using =RCHGetYahooQu
Andy
Thu Jun 12, 2014 8:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
At the moment, that's what Yahoo is sending back on their CSV file.
Hopefully, a temporary issue on their part.
On Thu, Jun 12, 2014 at 7:50 AM, Andy Yang acw_yang@... wrote:
>
> I'm using =RCHGetYahooQuotes("IBE.MC","n") and getting blanks rather than
> names that I can see on Yahoo Finance. Also for SAN.MC and TEF.MC. Any
> idea why?
>
Hopefully, a temporary issue on their part.
On Thu, Jun 12, 2014 at 7:50 AM, Andy Yang acw_yang@... wrote:
>
> I'm using =RCHGetYahooQuotes(
> names that I can see on Yahoo Finance. Also for SAN.MC and TEF.MC. Any
> idea why?
>
Tidak ada komentar:
Posting Komentar