MS Office 2003

[bunty18]

How we can change default file open or file save locations in MS Excel 2003, MS outlook.?

Is there any registry key that we can change to change the location of file save or file open.?

Can we select any network drive instead of My documents?


Thanks in advance

 

[bcastner]

Method #1: Send an email to all users

Give them in the email the following instructions:

By default, Outlook & Word & Access & Excel assume that you want to store documents in the My Documents folder or one of its subfolders, so it automatically displays the contents of the My Documents folder when you first display the Open or Save As dialog box. If you use a different folder for your data files, you will probably want Office applications to automatically display its contents in the Open and Save As dialog boxes instead.

To change your default documents folder, follow these steps:

Choose Tools, Options.

In the Options dialog box, click the File Locations tab.

Select Documents under File Types, and then click the Modify button.

In the Modify Location dialog box that appears, navigate to and select the folder that you want to be the default documents folder. When its name appears in the Look In text box, click OK.

Click the Close button in the Options dialog box.

Now when you display the Open dialog box, the folder you designated appears by default in the Look In box. By the same token, when you display the Save As dialog box, this folder appears in the Save In box.

Method #2: Push a registry change

I am going to assume that the environmental variables HOMEDRIVE and HOMEPATH were set during network logon. The example would then default to this path and a folder called "My Office Files". You can use literal pathing instead; e.g. "F:\Office Files" or even UNC paths.

---------- copy/paste beginning below this line
Registry Editor 5.0

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Outlook\Options
"DefaultPath"="%HOMEDRIVE%HOMEPATH%\My Office Files"

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Word\Options
"DefaultPath"="%HOMEDRIVE%HOMEPATH%\My Office Files"

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Excel\Options
"DefaultPath"="%HOMEDRIVE%HOMEPATH%\My Office Files"

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Access\Options
"DefaultPath"="%HOMEDRIVE%HOMEPATH%\My Office Files"

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Poserpoint\Options
"DefaultPath"="%HOMEDRIVE%HOMEPATH%\My Office Files"

----------- end copy/paste above this line

Method #3: Add to the Places Bar

A more persistent approach would be to add the folders you would like in the My Places Bar:

http://support.microsoft.com/?kbid=826214

Note that Office applications use a different set of registry entries for Common Dialogue boxes than XP generally, so TweakUI and other approaches will not work:

http://windowsxp.mvps.org/PlacesBar.htm

Office XP & 2003 already have a customize option for the Places bar. Again this only affects the Office Open & Save dialogs not the Open and Save common dialogs. Office XP & 2003 have the large and small icon option also. Some additional discussion of Office 2003 and Common Dialogue box customization:

. Add or delete a shortcut from the My Places bar

http://office.microsoft.com/en-us/assistance/HP030890961033.aspx

. Add a place to store your files

http://office.microsoft.com/en-us/assistance/HA011864981033.aspx

. How to customize the My Places bar in the "Open" and "Save As" dialog boxes in Office XP programs

http://support.microsoft.com/default.aspx?scid=kb;en-us;282087

. How to customize the My Places bar in both the Open and the Save As dialog boxes in Office 2003

http://support.microsoft.com/default.aspx?scid=kb;en-us;826214

. Customize the Places Bar in Office XP

http://www.petri.co.il/customize_the_places_bar_in_office_xp.htm

 

[bunty18]

IT IS NOT WORKING FOR MS POWERPOINT- registry


Thanks

 

[bcastner]

Change the original line:

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Poserpoint\Options
"DefaultPath"="%HOMEDRIVE%HOMEPATH%\My Office Files"

--to--

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Powerpoint\Options
"DefaultPath"="%HOMEDRIVE%HOMEPATH%\My Office Files"

It was a typo.

 

[smah]

Computers are so darn fussy..

 

[bunty18]

For powerpoint

I am using

sting name = DefaultPath
type = REG_EXPAND_SZ
value = U:\

it is not opening in U: drive

U is already mapped on the computer

 

[bcastner]

sting name = DefaultPath
type = REG_EXPAND_SZ
value = U:\

It is type STRING

 

[bunty18]

I have selected string. But still not working. Maybe POWERPOINT uses different string name.

 

[bcastner]

Maybe so.

Do this:

Use Method #1 for Powerpoint.
Then start regedit and examine this key:

HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Powerpoint\Options

Edit as suitable the .reg file above. Or, just export it and add its contents to the .reg file above.

 

[bunty18]

It is in recent folder list....not in options


Thanks

 

[bcastner]

Your are welcome.

You have to realize I do not have Office 2003 installed, so I could only make educated guesses. Microsoft seems to change the registry entry with each version of Office.

Best,
Bill Castner