Opening the file the way JOHN H. DAVIS recommended is how you'd open the Model, if you put all of the data on that worksheet into its own file.
You'd have to figure out how to reference the object for that workbook and worksheet by either using a "With" block or by setting a Workbook variable to it
Typically I open a file using the returned value from the Open method like this:
You can the use the Wbk var to establish a Worksheet var like so:
You then have a variety of ways to proceed. If you want to break the Model up into several files, you could use code to copy data
from one worksheet to another. Look up the Copy method and the PasteSpecial Method
If you want to summarize data from the Model based on criteria, you can make a lot of use of AutoFilter or
AdvancedFilter methods.
You can also use the Find Method in a loop.
You have many ways to proceed from here.
Bookmarks