Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to change file-open dialog box?

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to change file-open dialog box?

Thanks Dave. I have Excel 2007 and unfortunately it's different - the
"Tools" button is in the lower left of the box and offers only Delete,
Rename, Print, Map Network Drive, Properties, and Recover Previous Version.
There's no "add to places" option - maybe it's somewhere else?

I appreciate the input.

"Dave Peterson" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default How to change file-open dialog box?

Select your folder and then right click in the left panel itself, picking
'Add ...'

--
Jim
"Larryq22" wrote in message
...
| Thanks Dave. I have Excel 2007 and unfortunately it's different - the
| "Tools" button is in the lower left of the box and offers only Delete,
| Rename, Print, Map Network Drive, Properties, and Recover Previous
Version.
| There's no "add to places" option - maybe it's somewhere else?
|
| I appreciate the input.
|
| "Dave Peterson" wrote:
|
| 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
|


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to change file-open dialog box?

How easy - Thanks!!

"Jim Rech" wrote:

Select your folder and then right click in the left panel itself, picking
'Add ...'

--
Jim
"Larryq22" wrote in message
...
| Thanks Dave. I have Excel 2007 and unfortunately it's different - the
| "Tools" button is in the lower left of the box and offers only Delete,
| Rename, Print, Map Network Drive, Properties, and Recover Previous
Version.
| There's no "add to places" option - maybe it's somewhere else?
|
| I appreciate the input.
|
| "Dave Peterson" wrote:
|
| 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
|



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File Open dialog box is full-screen...???? Tiscali Excel Discussion (Misc queries) 3 May 11th 07 10:34 AM
File open dialog box [email protected] Excel Discussion (Misc queries) 1 March 21st 07 03:01 AM
Favourites button - File Open dialog box Aussie CPA Excel Discussion (Misc queries) 1 August 11th 05 02:42 PM
File open dialog Vaughan Excel Discussion (Misc queries) 0 May 12th 05 08:50 AM
File open dialog sorting TRICON Mike Excel Discussion (Misc queries) 2 May 9th 05 09:57 PM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"