Macro runs query that exports to Excel, now how to open additional Excel Workbooks?

[djrickel]

A macro behind a button runs a query that exports a few fields to Excel that are then linked to a couple of monster Workbooks. The button works fine but I cannot figure out how to ALSO do the following at the same time...



I need :
1) to suppress the message that says the Excel file already exists (which it does but I just want it overriden each time)
2) to prevent the same Excel file from automatically opening.
3) to automatically open the two monster Excel Workbooks linked to the exported data. Call them Plan1 and Plan2.

Thank you.

[ItsMe]

The answer to all three questions is to use VBA. Although, I am not quite sure why you want to open a workbook that is linked to Access.