Excel 2007 SP1 - VBA "Calculate" cannot be relied on!

R

Ron West

Referring to my post "Excel 2007 SP1 - How to do F9 in VBA code?" in
microsoft.public.excel.misc , it seems that VBA "Calculate" cannot be relied
on when using Reuters RtGet() libraries.

Pressing F9 does an immediate recalculate/refresh - but looping through
repetitive "Calculate" statements in VBA code does NOT refresh the Reuters
data cells.

If this is a bug in Excel 2007 SP1 (and not my fault somehow), then
Microsoft MUST FIX IT FOR SP2, else Excel will be worthless in major parts of
the Investment Banking world.
 
J

Jan Karel Pieterse

Hi Ron,
Referring to my post "Excel 2007 SP1 - How to do F9 in VBA code?" in
microsoft.public.excel.misc , it seems that VBA "Calculate" cannot be relied
on when using Reuters RtGet() libraries.

Pressing F9 does an immediate recalculate/refresh - but looping through
repetitive "Calculate" statements in VBA code does NOT refresh the Reuters
data cells.

If this is a bug in Excel 2007 SP1 (and not my fault somehow), then
Microsoft MUST FIX IT FOR SP2, else Excel will be worthless in major parts of
the Investment Banking world.
Click to expand...

I'd say this depends on how the reuters addin has been programmed whether this
is a bug or not.

Try if hitting control+alt+F9 does work.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
C

Charles Williams

Application.Calculate works fine for me in Excel 2007.

I suspect the problem is either in your vba code or the way your system is
setup or in the Reuters functions.
(Reuters functions are believed to do something strange like rewriting
themselves after a Calculation event)

Its hard to pin down without closer inspection.

Charles
___________________________________
London Excel Users Conference April 1-2
The Excel Calculation Site
http://www.decisionmodels.com
 
Top