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

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 )
Subject: 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

-- Regards,Tom Ogilvy"Charlie Woll" wrote in
message ...
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

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" wrote in message
...
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

Thank you, the your responses solved my problem
charlie

"Charles Williams" wrote in message
...
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" wrote in message
...
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