how do i delete a text file using ACCESS VBA code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am willing to delete a text file after i use it by using VBA code while my
form is running
 
to delete a file using VBA:
Kill "c:\yourfolder\yourfile.txt"

You may want to put some kind of if statement in to make sure the file
exists first.

Hth

Stu
 
I am willing to delete a text file after i use it by using VBA code while my
form is running
Click to expand...

Tongue slightly in cheek:

CurrentProject.Connection.Execute _
"DROP TABLE [TEXT;DATABASE=C:\FolderNameHere\;].FileNameHere#txt;"

Jamie.

--
 
I am willing to delete a text file after i use it by using VBA code while my
form is running
Click to expand...

Tongue slightly in cheek:

CurrentProject.Connection.Execute _
"DROP TABLE [TEXT;DATABASE=C:\FolderNameHere\;].FileNameHere#txt;"

Jamie.
Click to expand...

<g>

Yeah, that'd work.

Sort of like using a helicoptor rotor as a hedge trimmer though...

John W. Vinson [MVP]
 
Tongue slightly in cheek:
Click to expand...
CurrentProject.Connection.Execute _
"DROP TABLE [TEXT;DATABASE=C:\FolderNameHere\;].FileNameHere#txt;"
Click to expand...
<g>

Yeah, that'd work.

Sort of like using a helicoptor rotor as a hedge trimmer though...
Click to expand...

I figured the OP had in the title emphasized ACCESS VBA, as distinct
from vanilla VBA, so I thought, "What's the most _*ACCESS*_ way of
deleting a file...?" ;-)

Jamie.

--
 
I figured the OP had in the title emphasized ACCESS VBA, as distinct
from vanilla VBA, so I thought, "What's the most _*ACCESS*_ way of
deleting a file...?" ;-)
Click to expand...

Nah. None of us Access rubes ever use DDL; "DROP TABLE" is a foreign
language! :-{)


John W. Vinson [MVP]
 
Back
Top