Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using dir to get folder names
I am using dir(path, vbdirectory) to return the names of folders and files,
but instead of getting the folder name, I am getting "." How can I remedy this. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using dir to get folder names
Write your code to ignore it.
.. is the shortcut for the current directory ... is the shortcut for the parent directory In some versions of windows, you can go up the path with more and more dots. pjryan wrote: I am using dir(path, vbdirectory) to return the names of folders and files, but instead of getting the folder name, I am getting "." How can I remedy this. Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using dir to get folder names
MyPath = "c:\"
MyName = Dir(MyPath, vbDirectory) Do While MyName < "" If (GetAttr(MyPath & MyName) And vbDirectory) = vbDirectory Then MsgBox(MyName) End If MyName = Dir() Loop If this post helps click Yes --------------- Jacob Skaria "pjryan" wrote: I am using dir(path, vbdirectory) to return the names of folders and files, but instead of getting the folder name, I am getting "." How can I remedy this. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
using dir to get folder names
thanks - I know what the "." and ".." mean when listing directories and
folders, but it did not compute to me here! I did not let my loop continue running to see what would come next. When "." showed up first, I panicked. Thanks "Dave Peterson" wrote: Write your code to ignore it. .. is the shortcut for the current directory ... is the shortcut for the parent directory In some versions of windows, you can go up the path with more and more dots. pjryan wrote: I am using dir(path, vbdirectory) to return the names of folders and files, but instead of getting the folder name, I am getting "." How can I remedy this. Thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
using dir to get folder names
Sorry it is my oversight...the below is to extract folders alone...
-- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: MyPath = "c:\" MyName = Dir(MyPath, vbDirectory) Do While MyName < "" If (GetAttr(MyPath & MyName) And vbDirectory) = vbDirectory Then MsgBox(MyName) End If MyName = Dir() Loop If this post helps click Yes --------------- Jacob Skaria "pjryan" wrote: I am using dir(path, vbdirectory) to return the names of folders and files, but instead of getting the folder name, I am getting "." How can I remedy this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match file names listed in column with file names in folder | Excel Programming | |||
VBA help: need folder names | Excel Programming | |||
How to List the names of the subfolders present in the folder (path of folder is given in the textbox by user ) | Excel Programming | |||
How to Get Folder Names | Excel Programming | |||
Change names of files in a folder to match names in Excel Column | Excel Programming |