Thread: Dealing with windows 7 folder structure
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_747_] joel[_747_] is offline
external usenet poster
  
Posts: 1
Default Dealing with windows 7 folder structure

I don't have windows 7 but understand your proplem. I have two
suggestions. the folder you are looking at are links and not folder. I
assume you already know that. But sometimes with links, one method wil
recognize the links and other won't

1) Try "If folderExists

Set fs = CreateObject("Scripting.FileSystemObject")
fs.FolderExists(folderspec)


2) Try

FolderName = Dir[(pathname[, attributes])]

the attributes can be as follows

vbNormal 0 (Default) Specifies files with no attributes.
vbReadOnly 1 Specifies read-only files in addition to files with no
attributes.

vbHidden 2 Specifies hidden files in addition to files with no
attributes.

VbSystem 4 Specifies system files in addition to files with no
attributes. Not available on the Macintosh.

vbVolume 8 Specifies volume label; if any other attributed is
specified, vbVolume is ignored. Not available on the Macintosh.

vbDirectory 16 Specifies directories or folders in addition to files
with no attributes.

vbAlias 64 Specified file name is an alias. Available only on the
Macintosh.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184100

Microsoft Office Help

Reply With QuoteReply With Quote