View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to change file-open dialog box?

What version of excel are you using?


In xl2002 and xl2003, you can do file|open and then go to the parent folder of
the folder you want. Then click on the Tools button (top right corner) and
click "Add to Places".

If you're using xl2k, MS has a COM addin that's called Places.exe
that allows you to update the places list.

http://support.microsoft.com/default...;en-us;Q253338
INFO: Office Developer Samples and Tools Available for Download (Q253338)

====
I don't use xl2007 enough to know for sure, but it might be similar to
xl2002/xl2003.

Larryq22 wrote:

I store many Excel documents on our department's shared drive at work, and
I'd like to list that drive & path in the left side of the "File-Open" dialog
box. This is the box that appears when you click file...open, and on the
left side of the box is a column that lists a few places:

My Recent Documents
Desktop
My Documents
My Computer
My Network Places

I'd like to add one labeled "S drive - Institutional Effectiveness" (no
quotes) under My Network Places. How do I do this?

Thanks,
Larry


--

Dave Peterson