View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I think I would bring this up to my IT folks.

This is a setting that's kept in the windows registry. And for some (unknown to
me) reason, that setting is getting lost between logons.

======
Ah, one follow up...

Do you change this default location to a network drive? Is that network drive
_always_ available when you start excel?

For instance, if you're working on a laptop and change that location to your
home folder on your network drive--but then turn on the pc when you're not
connected to the network, excel will change it back to a location on your
harddrive (it has to use something).

If that's the case, you could use a macro that changes the default location (if
it's available) each time you open excel.

Put this in a General module of a new workbook. Then save this workbook in your
XLStart folder.

Option Explicit
Sub auto_open()

'Dim FSO As Scripting.FileSystemObject
Dim FSO As Object

Const myDefaultFolder As String = "U:\my u documents\excel"

'Set FSO = New Scripting.FileSystemObject
Set FSO = CreateObject("scripting.filesystemobject")

With Application
If FSO.FolderExists(folderspec:=myDefaultFolder) Then
.DefaultFilePath = myDefaultFolder
ChDrive myDefaultFolder
ChDir myDefaultFolder
Else
MsgBox "DefaultFilePath not reset, still: " & .DefaultFilePath
End If
End With
ThisWorkbook.Close savechanges:=False

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

code_master wrote:

Hello,
" In excel where you can set the default file location to somewhere
you regually use."
When this is done, it works fine if you close out of excel and go back in.
If the users logs of and then logs back on. The settings are then lost.
Only just started a networking job so may look like a thick question but
your help will be appreciated.
Thanks


--

Dave Peterson