How can I run VBA code that is on one WorkBook on the data in another Workbook?

[JeffLeites]

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?

[beyond Excel]

Hello.

>Start by defining two variables:

Please Login or Register  to view this content.

>Open the second workbook and assign it to the first variable:

Please Login or Register  to view this content.

>Assign the sheet of the second workbook where the data to be sorted is to the other variable:

Please Login or Register  to view this content.

>And sort the range by column A:

Please Login or Register  to view this content.

[JeffLeites]

Thanks for the reply, I'll kept a note of it for the next time. Actually after posting, I realized that what I was doing could better be done using one workbook with two sheets. I used code to copy the second workbook in the a second sheet in the first workbook, and went from there. Still required a lot of research for me since my VBA projects are far and few between. I was doing a project for a friend. I got it working today.

[beyond Excel]

Since you're so happy, you can -then- click the * at the bottom left of post #2 to say thanks for the help.