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.

To answer your question, this is a macro I recorded to open a series of
files in a particular order. It's nothing fancy, and I'm sure there
are more elegant ways to do this, but this is intuitive and you can
make it work for your application.

But more importantly, and this it totally an editorial so you can stop
reading now: it strikes me that requiring 50 workbooks to open
simultaneously makes your data subject to error, and is a system that
needs optimizing. Suggest a better methodology to the boss: it'll make
you look like a genius, and you'll be able to say I told you so when it
fails the next audit. Editorial ends, macro follows:

Sub Macro1()
Workbooks.Open Filename:="C:\ok2del a.xls"
ActiveWindow.WindowState = xlMinimized

Workbooks.Open Filename:="C:\ok2del b.xls"
ActiveWindow.WindowState = xlMinimized

Workbooks.Open Filename:="C:\ok2del c.xls"
ActiveWindow.WindowState = xlMinimized

End Sub

Thanks Dave.

The reason for all the files, is it contains budget information from several
different departments. Each department has their own "confidential"
information. So rather than have several tabs in one workbook, I have there
information in a seperate files that link into a consolidated file. Is there
an easier way? I am open to any and all suggestions.

Craig




"Dave O" wrote in message
ups.com...
To answer your question, this is a macro I recorded to open a series of
files in a particular order. It's nothing fancy, and I'm sure there
are more elegant ways to do this, but this is intuitive and you can
make it work for your application.

But more importantly, and this it totally an editorial so you can stop
reading now: it strikes me that requiring 50 workbooks to open
simultaneously makes your data subject to error, and is a system that
needs optimizing. Suggest a better methodology to the boss: it'll make
you look like a genius, and you'll be able to say I told you so when it
fails the next audit. Editorial ends, macro follows:

Sub Macro1()
Workbooks.Open Filename:="C:\ok2del a.xls"
ActiveWindow.WindowState = xlMinimized

Workbooks.Open Filename:="C:\ok2del b.xls"
ActiveWindow.WindowState = xlMinimized

Workbooks.Open Filename:="C:\ok2del c.xls"
ActiveWindow.WindowState = xlMinimized

End Sub

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.

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.

Is there a reason that after I saved the workspace, the view in all of my
files contained in my saved workspace have changed from Page Break Preview
with No Gridlines showing to Normal View with Gridlines showing?

There must be some trick to saving the workspace and keeping the settings I
had in my original files to be the same.

Any help??

Also, maybe it would just be easier to run the macro mentioned earlier in
this thread. The problem is I am not what you call an "Expert" in excel
programing. In fact, I am a novice who just so happens to no more than the
rest of my co-workers so I am the "Expert" only in my office.

So how would I go about writing the macro. Do I create a button or
keystroke and record the opening of each file and then put the minimization
in the code?

Please help!! Thanks!!




"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.

Bump
"Craig" wrote in message
...
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.