When does workbook_open event trigger?

Question

Hello

I have an Excel workbook which has several calculations in it (it fetches data from a third party application). I want to run a macro in this workbook when I open it. However I want to first complete all calculations in the workbook and then trigger the macro. My question is: When does the workbook_open even trigger? Is it after all calculations are completed or immediately after the workbook opens (calculations and macro run simultaneously).

Thanks for help in advance.

Regards,

Pawan

Answer 1

Hi

I believe it calculates before executing the event macro. You could do your  test with a copy of your workbook.

Here is a small test I did, not sure if this is valid in your case.

In cell A1, I placed the formula =Now() and formatted as hh:mm:ss. That  giving me a dynamic time.

Then I type this small macro in a Workbook Open Event

Private Sub Workbook_Open()

Range("A1").Copy

Range("B1").PasteSpecial xlPasteValues

End Sub

I waited a few minutes and opened the file, It pasted the new time in cell B1

Answer 2

Hi,

You could do something like this

Private Sub Workbook_Open()

Do Until Application.CalculationState = xlDone

   DoEvents

Loop

'Your code

End Sub