I set up a control Workbook 1 with code to select Workbook 2 (from Windows Explorer) which contains the data I want to process.
When Workbook 2 is selected, I have a button on the control Workbook 1 that opens and activates Workbook 2.

The first thing I want to do is sort Workbook 2 by Column "A" using code that is in the control program, Workbook 1 (which at this point is inactive).

It won't let me Is there a way?