<div>
Here's one method...<br />
<br />
Dim strFile As String<br />
<br />
strFile = Dir$(&quot;c:\yourfolder\&quot;)<br />
<br />
While Len(Trim$(strFile)) &gt;&nbsp;0<br />
<br />
&nbsp; &nbsp; ' Import your file here based on the filename being in the string variable strFile<br />
<br />
&nbsp; &nbsp; ' YOUR CODE HERE<br />
<br />
&nbsp; &nbsp; ' After processing, delete the specific file &amp;&nbsp;see if there are any more...<br />
<br />
&nbsp; &nbsp; Kill strFile<br />
<br />
&nbsp; &nbsp; strFile = Dir$()<br />
<br />
Wend<br />
<br />
<br />
<br />
BFN,<br />
<br />
fp.
</div>


Here's one method...

Dim strFile As String

strFile = Dir$("c:\yourfolder\")

While Len(Trim$(strFile)) > 0

    ' Import your file here based on the filename being in the string variable strFile

    ' YOUR CODE HERE

    ' After processing, delete the specific file & see if there are any more...

    Kill strFile

    strFile = Dir$()

Wend



BFN,

fp.

<div>
Sorry, for:<br />
<br />
strFile = Dir$(&quot;c:\yourfolder\&quot;)<br />
<br />
Read:<br />
<br />
strFile = Dir$(&quot;c:\importfolder\&quot;)
</div>


Sorry, for:

strFile = Dir$("c:\yourfolder\")

Read:

strFile = Dir$("c:\importfolder\")

<div>
Apologies again,<br />
<br />
Replace:<br />
strFile = Dir$(&quot;c:\yourfolder\&quot;)<br />
<br />
With:<br />
strFile = Dir$(&quot;c:\importfolder\*.*&quot;<wbr />)<br />
<br />
<br />
(It's 3:28am local time, btw!)
</div>


Apologies again,

Replace:
strFile = Dir$("c:\yourfolder\")

With:
strFile = Dir$("c:\importfolder\*.*")


(It's 3:28am local time, btw!)

<div>
That works <br />
<br />
Thank You
</div>


<div>
You're welcome.<br />
<br />
Thanks for closing the question so promptly.<br />
<br />
BFN,<br />
<br />
fp.
</div>


You're welcome.

Thanks for closing the question so promptly.

BFN,

fp.

<div>
<div class="content wysiwyg-content">
I have a program that imports data from a text file. &nbsp;I am able to import the data from the specific file by specifying the exact path. &nbsp;I would like to know how to import each file in the directory regardless of the name of the file. &nbsp;After the file has been imported I would like it deleted. &nbsp;<br />
<br />
Directory to import from is c:\importfolder<br />
<br />
Thank You
</div>
</div>


I have a program that imports data from a text file.  I am able to import the data from the specific file by specifying the exact path.  I would like to know how to import each file in the directory regardless of the name of the file.  After the file has been imported I would like it deleted.  

Directory to import from is c:\importfolder

Thank You

Import all files in a directory in Visual Basic

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.