Thread: GetFolder error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default GetFolder error

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