I have the following piece of code

Set FSO = CreateObject("Scripting.fileSystemObject")

Set RootFolder = FSO.getFolder(myFolder)


myFolder = "K:" (with other folders)

I get an error if I haven't accessed the mapped K drive. Does anyone have
any suggestions as to how to avoid this error?

Thanks,
Barb Reinhardt

Set FSO = CreateObject("Scripting.fileSystemObject")
If FSO.FolderExists(folderspec) then
Set RootFolder = FSO.getFolder(myFolder)
else
msgbox("Folder : " & myfolder & " Doesn't Exist")

end if


"Barb Reinhardt" wrote:

I have the following piece of code

Set FSO = CreateObject("Scripting.fileSystemObject")

Set RootFolder = FSO.getFolder(myFolder)


myFolder = "K:" (with other folders)

I get an error if I haven't accessed the mapped K drive. Does anyone have
any suggestions as to how to avoid this error?

Thanks,
Barb Reinhardt

I guess I need to clarify my question. The K drive does exist, but it only
sees it once I manually access it by typing "K:" in a browser. I want to
avoid having to do this. How do I do that?

"Joel" wrote:

Set FSO = CreateObject("Scripting.fileSystemObject")
If FSO.FolderExists(folderspec) then
Set RootFolder = FSO.getFolder(myFolder)
else
msgbox("Folder : " & myfolder & " Doesn't Exist")

end if


"Barb Reinhardt" wrote:

I have the following piece of code

Set FSO = CreateObject("Scripting.fileSystemObject")

Set RootFolder = FSO.getFolder(myFolder)


myFolder = "K:" (with other folders)

I get an error if I haven't accessed the mapped K drive. Does anyone have
any suggestions as to how to avoid this error?

Thanks,
Barb Reinhardt

Look at the filedialog method. You can specify the default drive and default
filename.

"Barb Reinhardt" wrote:

I guess I need to clarify my question. The K drive does exist, but it only
sees it once I manually access it by typing "K:" in a browser. I want to
avoid having to do this. How do I do that?

"Joel" wrote:

Set FSO = CreateObject("Scripting.fileSystemObject")
If FSO.FolderExists(folderspec) then
Set RootFolder = FSO.getFolder(myFolder)
else
msgbox("Folder : " & myfolder & " Doesn't Exist")

end if


"Barb Reinhardt" wrote:

I have the following piece of code

Set FSO = CreateObject("Scripting.fileSystemObject")

Set RootFolder = FSO.getFolder(myFolder)


myFolder = "K:" (with other folders)

I get an error if I haven't accessed the mapped K drive. Does anyone have
any suggestions as to how to avoid this error?

Thanks,
Barb Reinhardt

Use the below before you set the folder object

fso.DriveExists()
fso.FolderExists()

If this post helps click Yes
---------------
Jacob Skaria


"Barb Reinhardt" wrote:

I have the following piece of code

Set FSO = CreateObject("Scripting.fileSystemObject")

Set RootFolder = FSO.getFolder(myFolder)


myFolder = "K:" (with other folders)

I get an error if I haven't accessed the mapped K drive. Does anyone have
any suggestions as to how to avoid this error?

Thanks,
Barb Reinhardt

Some network devices (printers and drives) seem to just disappear. You may be
able to go into windows explorer and refresh the devices and then excel will
(er, should) see them right away.

There is a parm available in the windows registry that indicates how long before
any device is "lost". But I don't recall that key.

Thank goodness for google!

How Autodisconnect Works in Windows NT and Windows 2000
http://support.microsoft.com/default...;en-us;Q138365

This is the commandline you'd want to run if you want to avoid editing the
registry:
net config server /autodisconnect:-1





Barb Reinhardt wrote:

I have the following piece of code

Set FSO = CreateObject("Scripting.fileSystemObject")

Set RootFolder = FSO.getFolder(myFolder)

myFolder = "K:" (with other folders)

I get an error if I haven't accessed the mapped K drive. Does anyone have
any suggestions as to how to avoid this error?

Thanks,
Barb Reinhardt

--

Dave Peterson

Sometimes my mapped drive "disappears". I used the UNC mapping instead (ie:
\\ABCServer\MyDir\ ) and avoid the problem all together. As long as the
original source in question is attached to the network and I have the appro.
security rights, it should work without an issue.
--
Thx
MSweetG222



"Dave Peterson" wrote:

Some network devices (printers and drives) seem to just disappear. You may be
able to go into windows explorer and refresh the devices and then excel will
(er, should) see them right away.

There is a parm available in the windows registry that indicates how long before
any device is "lost". But I don't recall that key.

Thank goodness for google!

How Autodisconnect Works in Windows NT and Windows 2000
http://support.microsoft.com/default...;en-us;Q138365

This is the commandline you'd want to run if you want to avoid editing the
registry:
net config server /autodisconnect:-1





Barb Reinhardt wrote:

I have the following piece of code

Set FSO = CreateObject("Scripting.fileSystemObject")

Set RootFolder = FSO.getFolder(myFolder)

myFolder = "K:" (with other folders)

I get an error if I haven't accessed the mapped K drive. Does anyone have
any suggestions as to how to avoid this error?

Thanks,
Barb Reinhardt

--

Dave Peterson