Make excel recalculate every nth second

E

eloquentia

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

This was possible through the On Time command in Visual Basic.

With this feature being left out in the 2008 version, what should I do?
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

This was possible through the On Time command in Visual Basic.

With this feature being left out in the 2008 version, what should I do?
Click to expand...

One way would be to use an AppleScript application.

Paste this into Script Editor:

global iteration_interval

on idle
tell application "Microsoft Excel"
try
calculate
end try
end tell
return iteration_interval
end idle

on run
set iteration_interval to 5
end run

Save it as an application, making sure the "Stay Open" checkbox is
checked.

Note that there's no error checking, and as written it calculates all
open workbooks. If I were to develop this as an application, I'd
probably want to (at least)

a) Have it open the file if it isn't open
b) Only calculate the one workbook or worksheet if the workbook is open
c) Quit if the XL quits.
 
Top