GetFolder error

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

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
 
Use the below before you set the folder object

fso.DriveExists()
fso.FolderExists()

If this post helps click Yes
 
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?
 
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.aspx?scid=kb;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
 
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.
 
Back
Top