I will try this also. Is there a way to save the workspace in a manner
where you arrange the files in different parts of the screen ie. all of
dept#4 in the upper left corner and all dept #3 in the lower right hand
corner? It seems to work when all are minimized, but can you save the
workspace




"Eddie Holder" wrote in message
...
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.