How to get add-in to reference the workbook I'm actively using (and not itself)

I created an excel add-in called "SQLRunner.xlam" and added it to my quick-access toolbar.

The purpose of the add-in is to filter my worksheet data based on an SQL SELECT statement that I provide real-time and then put the query results back into my workbook in a new worksheet.
I want to be able to use this add-in on any workbook/worksheet that I have open. Today it might be a sales worksheet, tomorrow it could be #visitors to the site, the next day it could be pizza orders, etc.

If I put the VBA code into a module of a normal .xlsm file, it works fine. But when I use it as an add-in, it doesn't work. It's because it's referencing itself (the .xlam workbook) rather than the workbook I'm trying to select from.

Let's say I have the following in [Sheet1] of "pizza.xlsx"

OrderID	Customer	Topping
1	Bob	Pepperoni
2	Mary	Cheese
3	Bob	Sausage
4	Joe	Sausage

I want to click my "SQLRunner" add-in button from the quick-access and apply a SELECT statement to the data in [Sheet1]. If I say "SELECT * from [Sheet1$A:C] where Customer='Bob' " then it'll print out the following into a new worksheet in my pizza.xlsx workbook.

[Sheet 2] of pizza.xlsx

OrderID	Customer	Topping
1	Bob	Pepperoni
3	Bob	Sausage

How should I change the "ThisWorkbook" references to use the worksheet I'm actively editing (here it's pizza.xlsx) rather than it referencing itself (SQLRunner.xlam) ?

Please Login or Register  to view this content.

Change ThisWorkbook to ActiveWorkbook?