Let VBA Code Run when using other Office Programs

Not long ago, I had gotten a solution to allow for a Query Table to be refreshed. Since then, I have found a problem that needs to be fixed. Here is the code I have right now:

Module Code:

Please Login or Register  to view this content.

Class Code:

Please Login or Register  to view this content.

My problem is with the 'Set wd = ActiveWorkbook.Sheets("Data")' part of the code. As long as the workbook Runescape Guide is active, nothing wrong happens. However, when I am using another Office Document at time of Query Refresh, it stops working. Is there a code that can be added to let macro run while the workbook is inactive?

ActiveWorkbook refers to the workbook that is selected/active. ThisWorkbook always refers to the workbook where the macro was loaded from.

@grimes0332: I think I pretty much said that a while back

What we both mean is that this

Please Login or Register  to view this content.

should be this

Please Login or Register  to view this content.