View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] richardconers@yahoo.com is offline
external usenet poster
 
Posts: 2
Default change curdir to a folder on a network

I would like VBA to change the folder that is displayed when using the
(workbook) OPEN dialog box to a folder that resides on a network
drive/computer.

let's say the file open dialog box opens to
"C:\OldFolder" (and curdir displays "C:\OldFolder" )

let's say I want the file open dialog box to display a folder on a
network "\\Newton\c\FolderIWant"

chdrive "\\Newton\c" doesn't work
chdir "\\Newton\c\FolderIWant" " doesn't work

and

Application.DefaultFilePath = "\\Newton\c\FolderIWant"
msgbox Application.DefaultFilePath
does give me "\\Newton\c\FolderIWant" [in the message box]
HOWEVER
neither curdir nor file open dialog box changes to
"\\Newton\c\FolderIWant"

They both still are on "C:\OldFolder"
What do I do?????
Thank you!