If you open the files in the order you want and also minimise them all,
choose File- Save Workspace - EnterName and your done!

When you open the workspace, it will open all the files in the order and
window state as when you saved the workspace.

If you want code to file all the files in a folder on a worksheet, let me
know and I'll post it. The solution above should work though
--


Alwyas Trying
Eddie


"Craig" wrote:

I have a strange question. I have a task in which I open up to 50 Excel
files open up at the same time. They all link to each other and I need all
of them open to ensure everything stays updated. Here is my question:

Is there an automatic way to arrange the minimized excel files I have open
in alphabetical order? Right now I spend tons of times "hunting" for the
particular file I need.

When I open all of these files, some open up minimized and some I have to
minimize. But once I have manually minimized all the files, I would like to
sort them alphabetically, otherwise I spend extra time searching for the
file I need. I hope this makes sense.

Just wondering if there is a macro or program I can run to sort these files
so I can find them easier.

Thanks for any help.