I am trying to create an Excel file that will be used as a front end program to open up several different Excel files in a sequential order and run procedures that have been created within each file.

So far I have created a userform in Excel that will open the Excel files, but now I need to know how to run the procedures in each file. Is this possible?

Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.

__________________
Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.

After searching for sometime on the web I found the answer. It was actually quite simple. The following line of code executes my procedure from another file:

Application.Run ("FileName.xls!ProcedureName")

Problem solved! Maybe this will help someone.

Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.