Wait is interrupting calculation

[zx10]

I have an excel file with an addin. When i open the file the addin automatically does a recalc. I want to automate opening the file, allowing it to refresh and then saving some columns to a csv file and close the file. When i open the file it takes about 30 seconds to refresh all formulas.

In my VBA i call calculateAll 2 times and then Wait for more than a minute. the formulas never completely refresh. I have added multiple wait calls adding up to more than 3 minutes and the formulas never full refresh.

Any help greatly appreciated

sub grrr
Application.CalculateFull
Application.CalculateFull

Application.Wait (Now + TimeValue("0:00:20"))
Application.Wait (Now + TimeValue("0:00:20"))
Application.Wait (Now + TimeValue("0:00:20"))
....

end sub

[AlphaFrog]

Create a separate procedure that does what you want to do after the calculations. Then use Application.OnTime to call that procedure 2 minutes in the future.

Please Login or Register  to view this content.

[Marc L]

Or just checking obviously the CalculationState property, to see in VBA help …

[zx10]

Thanks AlphaFrog, that works if i open the file manually.

But when i use windows task scheduler excel crashes. The details from event viewer are:

Faulting application name: EXCEL.EXE, version: 14.0.7264.5000, time stamp: 0x5fda5e72
Faulting module name: EXCEL.EXE, version: 14.0.7264.5000, time stamp: 0x5fda5e72
Exception code: 0xc0000005
Fault offset: 0x001de26d
Faulting process id: 0x870
Faulting application start time: 0x01d769f76cd40544
Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
Faulting module path: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
Report Id: aeab09ae-d5ea-11eb-99b0-000c295fc34e



Thanks in advance