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
Bookmarks