Workbook_activate or workbook_open?

**Lv27** · 07-05-2012, 03:00 AM

Hey

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

Please Login or Register  to view this content.

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!

**arlu1201** · 07-05-2012, 03:13 AM

It will be good if you use Workbook_open. If you use workbook_activate, each time you activate the workbook, the code will run. But it will run only once when the workbook is open, even if its activated multiple times, if you use the workbook_open event.

**Lv27** · 07-05-2012, 05:05 AM

A very nice explanation, thanks a lot!

**arlu1201** · 07-05-2012, 05:23 AM

You are welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save