Application.Calculatefull function

[Charlie Woll]

I have used the Application.CalculateFull function in VB Excel 2002. Folks
who use this workbook with earlier versions of Excel get an error msg. Is
there a way to update their version to use this call without upgrading their
version of excel? Is there a DLL that I can copy to their computer to
accomplish this?

charlie

 

[Tom Ogilvy]

No. You need to make you code more robust I suspect. xl2000 supports
CalculateFull. xl97 doesn't. Look at
Val(Application.Version)

--------------------------

From a post by Charles Williams:

From: Charles Williams ([email protected])
Subject: Re: Ctrl+Alt+F9
View: Complete Thread (7 articles)
Original Format
Newsgroups: microsoft.public.excel.programming
Date: 2000-11-10 01:10:45 PST

Hi Stephane,

Ctrl-Alt-F9 does a complete calculation of every formula.
F9 does a "smart recalculation" based on only recalculating the parts of the
spreadsheet that Excel thinks need to be recalculated.

In Excel 2000 [and later]:
Application.calculate ''' f9
application.calculatefull ''' ctrl-alt-f9

in Excel97
application.calculate ''' f9
SendKeys "%^{F9}", True ''' ctrl-alt-f9

HTH
Charles

 

[Charles Williams]

calculatefull is available in Excel2000 and later. prior to that you have to
use sendkeys to simulate Ctr-alt-F9

if val(application.version)<9 then

Application.SendKeys "%^{F9}"
DoEvents

else
application.calculatefull
endif

 

[Charlie Woll]

Thank you, the your responses solved my problem
charlie