VB6 How to retrieve all file name from a Folder

[Lennie]

Hi Good Friends,
I need your help. Please help me.

My company Business Analyst asked me to develop a application to retrieve all the SALESDEPT files names and not the Contents from this folder F:\SalesDept\ and write it to a TEXTFILE and after that save it into this folder F:\ViewFileName

I have not done it before and doesn't know how to do it. I need your help to share with me sample coding so that I can learned from it.

Thank you for helping me.

[saltkev]

Hi

Do you have to use VB/VBA, a batch file or simple command issued from the command prompt might do the job. The batch file can be associated with a windows shortcut.

Batch file lines as follows:-

@echo off
cls

F:

cd\salesdept

dir /a:-d /b /o:n > yourfile.txt

exit

This batch file will send a directory of the files in the current directory "SalesDept" to a text file of your choice. You can create a batch file in notepad type in the above lines and save it with the file extension .Bat "Your_filename.bat". Run from the command line or associate with a windows shortcut. Type & enter "dir /?" to view all the options & switches associated with Dir. Hope this make sense and is of some use.

Kev

[mstraf]

Look at the MSDN documentation of the Dir function

A simple example:

dim s as string
s = Dir("F:\SalesDept\*")
while len(s) > 0
'' save s into a file
s = Dir '' get next file
Wend

[Lennie]

Look at the MSDN documentation of the Dir function

A simple example:

dim s as string
s = Dir("F:\SalesDept\*")
while len(s) > 0
'' save s into a file
s = Dir '' get next file
Wend

------------------------------------------------------
Hi mstraf
Thank you for trying to help me. Appreciate that very much.
Regrading your suggestion looking at MSDN what is the URL Address ?

Regarding the sample coding, The Business Analyst reguest is to retrieve only the File Name and not the content of the file.

[mstraf]

Regrading your suggestion looking at MSDN what is the URL Address ?

You should have MSDN installed in your computer, type DIR in the IDE, click on it and press F1 for help
Otherwise, you can find the documentation online:

http://msdn.microsoft.com/en-us/libr...(v=VS.60).aspx

As you can see, Dir returns the name of the file, not the content...