Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 18th 07, 03:04 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 2
Default how can i change my default working folder to a networked folder?

i am trying to change my default working folder from "my documents" to a
folder on my network personal drive( drive X) how can i change this so it by
default will always open in the network drive? excell 2003

  #2   Report Post  
Old April 18th 07, 03:24 PM posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 510
Default how can i change my default working folder to a networked folder?

try changing it in you Word options, that sets it for excel, too, in older
versions

"wizard1154" wrote:

i am trying to change my default working folder from "my documents" to a
folder on my network personal drive( drive X) how can i change this so it by
default will always open in the network drive? excell 2003

  #3   Report Post  
Old April 18th 07, 05:05 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default how can i change my default working folder to a networked folder?

Have you tried changing the default file location in ToolsOptionsGeneral?


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 07:04:03 -0700, wizard1154
wrote:

i am trying to change my default working folder from "my documents" to a
folder on my network personal drive( drive X) how can i change this so it by
default will always open in the network drive? excell 2003


  #4   Report Post  
Old April 18th 07, 06:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 2
Default how can i change my default working folder to a networked fold

yes tried that but to no avail

"Gord Dibben" wrote:

Have you tried changing the default file location in ToolsOptionsGeneral?


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 07:04:03 -0700, wizard1154
wrote:

i am trying to change my default working folder from "my documents" to a
folder on my network personal drive( drive X) how can i change this so it by
default will always open in the network drive? excell 2003



  #5   Report Post  
Old April 18th 07, 07:29 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default how can i change my default working folder to a networked fold

I used to have this problem if I opened excel when I wasn't mapped to my network
drive.

I created a file in my XLStart folder that tried to change that setting each
time I opened excel.

Option Explicit
Sub auto_open()

'Dim FSO As Scripting.FileSystemObject
Dim FSO As Object

Const myDefaultFolder As String = "X:\my folder\myfolder2l"

'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

=======
I would guess that if you don't have the authorization to write to the windows
registry that this setting may not be kept for you. You may want to test to see
if other changes are kept, too.

If they're not, I'd ask the IT folks why it wasn't working.

wizard1154 wrote:

yes tried that but to no avail

"Gord Dibben" wrote:

Have you tried changing the default file location in ToolsOptionsGeneral?


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 07:04:03 -0700, wizard1154
wrote:

i am trying to change my default working folder from "my documents" to a
folder on my network personal drive( drive X) how can i change this so it by
default will always open in the network drive? excell 2003




--

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
... I'd like to change the Default Folder... Dr. Darrell Excel Discussion (Misc queries) 4 September 11th 07 04:12 PM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven Excel Discussion (Misc queries) 1 January 24th 06 03:28 PM
How do I change the default folder when I import data? marvmart Excel Worksheet Functions 0 January 11th 06 04:58 PM
Change Default Add-in Folder compound Excel Discussion (Misc queries) 2 July 13th 05 10:25 PM
"Save As" folder -- can I default this to the same folder as origi Mike Excel Discussion (Misc queries) 1 June 11th 05 12:06 AM


All times are GMT +1. The time now is 11:50 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017