Hey

I've made a simple macro that enables the document to refresh data from Bloomberg automatically...

Private Sub workbook_activate()
    Application.Run "Refreshentireworkbook"
End Sub
But can anyone of you tell me if it's right to use workbook_active - or is workbook_open the appropriate one, when I want the data to refresh every time I open the document (I don't really know the difference between those two)..?

Thanks!