<div>
Seems like you already have it ... all but<br />
<br />
Chris<br />

<pre><code id="code-8057670">Sub DeleteFile(ByVal FileToDelete As String)
Dim aFile As String
sTemp = Environ(&quot;TEMP&quot;)
aFile =  stemp &amp; &quot;\test.log&quot; 
If Len(Dir$(aFile)) &gt; 0 Then
     Kill aFile
End If</code></pre>
</div>


Seems like you already have it ... all but

Chris


Sub DeleteFile(ByVal FileToDelete As String)
Dim aFile As String
sTemp = Environ("TEMP")
aFile =  stemp & "\test.log" 
If Len(Dir$(aFile)) > 0 Then
     Kill aFile
End If

<div>
Thanks for your help<br />
TM
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
can you help me with my macro to delete a text file? I need to erase the file test.log (if exist) in the location of the system folder &quot;%TEMP%\test.log&quot;. <br />
To be precise: &quot;%TEMP%&quot; = Environ(&quot;TEMP&quot;)<br />
Below is the code you need to edit.<br />
<br />
Thanks.<br />
<br />
Regards,<br />
TM<br />

<pre><code id="code-8057627">Sub DeleteFile(ByVal FileToDelete As String)
Dim aFile As String
sTemp = Environ(&quot;TEMP&quot;)
aFile =  '&lt;-You need to set the path to the file (test.log), it can be deleted. 
If Len(Dir$(aFile)) &gt; 0 Then
     Kill aFile
End If</code></pre>
</div>
</div>


Hi,
can you help me with my macro to delete a text file? I need to erase the file test.log (if exist) in the location of the system folder "%TEMP%\test.log". 
To be precise: "%TEMP%" = Environ("TEMP")
Below is the code you need to edit.

Thanks.

Regards,
TM

How to verify the existence of the file and delete it?

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.

Visual Basic Classic

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.