Excel - Access Integration
 

I have an Access DB where I create a dept table from a department selected in
the form.

Then when Show Projects button is pressed in that form, this table/record is
read by a separate Excel workbook and it does some calculations and creates a
report.

I also need to be able to run in Excel workbook standalone. It has its own
UI where if a department is selected, same calculations are done.

How do I know whether the query is coming from Access (press of the button
in the form) or the Excel workbook is opened standalone.

Sorry if this is an Access question. I was not sure.

Thanks,