how to permanently customize the Default Folder option on Excel 2000 in network

  • Thread starter Thread starter freeposte
  • Start date Start date
F

freeposte

Correction of my e-first e-mail :
Good day dear members of the microsoft.public.excel.misc newsgroup. Please I
need Your allways priceless advises. I'm working with Excel 2000 installed
directly installed at the hard drive of my computer. I cannot permanently
customize
the Default Folder option in "Tools\Options\Default Folder\General". It
works only during the current Windows session, a pc reboot would change
again the Default Folder option to the former one.

Is there any way to permanently customize the Default Folder option.

Thank-You

Octavio
 
Octavio

I would try to re-register Excel after you have entered your folder path in
the Default dialog box.

Close out Excel then go to Start>Run and type in "Excel.exe /regserver"(no
quotes).

Re-boot Windows and???

If this does not work you could try a registry change directly.

Assuming you are aware of the precautions taken when editing the Registry and
know how to restore a recent backup of same.......

If not, maybe have a look here first...scroll down to "Registry editing tips"

http://www.activewin.com/tips/reg/index.shtml


Start>Run "regedit"(no quotes)

Drill down to HKEY_Current_User\Software\Microsoft\Office\9.0\Excel\Options

Look for "DefaultPath"and select. Edit>Modify. Type your path in here and
close.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
And if all that fails, maybe you could add a line to your auto_open procedure
(or workbook_open event) for you personal.xl* file.

Application.DefaultFilePath = "C:\My Documents\excel"

Or just add another workbook to your XLStart folder that has one procedure in
it:

Option Explicit
Sub auto_open()
Application.DefaultFilePath = "C:\My Documents\excel"
ThisWorkbook.Close savechanges:=False
End Sub

========

I've never seen a good explanation why these settings don't take. Can you can
entries in the registry under your version of windows (and you're usual login
id)?
 
Back
Top