My work book prompts me for a txt file that I read data onto one of
my sheets to, and I want to delete this txt file after the read.

I'm not sure how to do this, can anyone offer advice

Thanks,

Jeff W.

You could use VBA's Kill statement to remove the text file; however, you
should understand that the removal is permanent... a copy of the Kill'ed
file will NOT be in your Recycle Bin afterwards. I mention this because if
you read the file in, then Kill it, and your system should crash before you
save the spreadsheet, the data will be lost and the original text file will
not be recoverable. You could consider using the FileCopy statement to copy
the file into a Temp directory, then Kill it from its original location;
that way, you could delete it with your regular Temp directory clean up
sometime later on when you have safely saved the spreadsheet and/or backed
up your system.

Rick


"Jeff W." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> My work book prompts me for a txt file that I read data onto one of
> my sheets to, and I want to delete this txt file after the read.
>
> I'm not sure how to do this, can anyone offer advice
>
> Thanks,
>
> Jeff W.
>

Thanks for the reply Rick, however I do understand the risks of data loss
and the particular txt file is generated by another application, it isnt
sensitive
data or un replaceable data, so that wount be an issue.

Can you show me exmaple of how to use the kill command to delete a txt file?

Thanks,

Jeff W.




"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> You could use VBA's Kill statement to remove the text file; however, you
> should understand that the removal is permanent... a copy of the Kill'ed
> file will NOT be in your Recycle Bin afterwards. I mention this because if
> you read the file in, then Kill it, and your system should crash before
> you save the spreadsheet, the data will be lost and the original text file
> will not be recoverable. You could consider using the FileCopy statement
> to copy the file into a Temp directory, then Kill it from its original
> location; that way, you could delete it with your regular Temp directory
> clean up sometime later on when you have safely saved the spreadsheet
> and/or backed up your system.
>
> Rick
>
>
> "Jeff W." <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> My work book prompts me for a txt file that I read data onto one of
>> my sheets to, and I want to delete this txt file after the read.
>>
>> I'm not sure how to do this, can anyone offer advice
>>
>> Thanks,
>>
>> Jeff W.
>>
>

On Oct 13, 10:08 am, "Jeff W." <part_ma...@verizon.net> wrote:
> Thanks for the reply Rick, however I do understand the risks of data loss
> and the particular txt file is generated by another application, it isnt
> sensitive
> data or un replaceable data, so that wount be an issue.
>
> Can you show me exmaple of how to use the kill command to delete a txt file?
>
> Thanks,
>
> Jeff W.
>
> "Rick Rothstein (MVP - VB)" <rickNOSPAMn...@NOSPAMcomcast.net> wrote in
> messagenews:(E-Mail Removed)...
>
> > You could use VBA's Kill statement to remove the text file; however, you
> > should understand that the removal is permanent... a copy of the Kill'ed
> > file will NOT be in your Recycle Bin afterwards. I mention this because if
> > you read the file in, then Kill it, and your system should crash before
> > you save the spreadsheet, the data will be lost and the original text file
> > will not be recoverable. You could consider using the FileCopy statement
> > to copy the file into a Temp directory, then Kill it from its original
> > location; that way, you could delete it with your regular Temp directory
> > clean up sometime later on when you have safely saved the spreadsheet
> > and/or backed up your system.
>
> > Rick
>
> > "Jeff W." <part_ma...@verizon.net> wrote in message
> >news:(E-Mail Removed)...
> >> My work book prompts me for a txt file that I read data onto one of
> >> my sheets to, and I want to delete this txt file after the read.
>
> >> I'm not sure how to do this, can anyone offer advice
>
> >> Thanks,
>
> >> Jeff W.

Hello Jeff,

If the file isn't in the current directory you need to include the
full directory path with the file name and type.

Kill "Sample.txt"

Sincerely,
Leith Ross

For future reference, you can type any VBA statement name, function name,
keyword, etc. into the code or Immediate window and, with the cursor next to
or in that word, press F1 for help on it. As for you example.... just
include the full path plus the filename as a String argument to it.

Using String Constant
==================
Kill "c:\folder1\folder2\etc\YourTextFile.txt"

Using String Variable
==================
Dim FilePathName As String
......
......
FilePathName = TextBox1.Text
Kill FilePathName


Rick


"Jeff W." <(E-Mail Removed)> wrote in message
news:%23$(E-Mail Removed)...
> Thanks for the reply Rick, however I do understand the risks of data loss
> and the particular txt file is generated by another application, it isnt
> sensitive
> data or un replaceable data, so that wount be an issue.
>
> Can you show me exmaple of how to use the kill command to delete a txt
> file?
>
> Thanks,
>
> Jeff W.
>
>
>
>
> "Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)...
>> You could use VBA's Kill statement to remove the text file; however, you
>> should understand that the removal is permanent... a copy of the Kill'ed
>> file will NOT be in your Recycle Bin afterwards. I mention this because
>> if you read the file in, then Kill it, and your system should crash
>> before you save the spreadsheet, the data will be lost and the original
>> text file will not be recoverable. You could consider using the FileCopy
>> statement to copy the file into a Temp directory, then Kill it from its
>> original location; that way, you could delete it with your regular Temp
>> directory clean up sometime later on when you have safely saved the
>> spreadsheet and/or backed up your system.
>>
>> Rick
>>
>>
>> "Jeff W." <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> My work book prompts me for a txt file that I read data onto one of
>>> my sheets to, and I want to delete this txt file after the read.
>>>
>>> I'm not sure how to do this, can anyone offer advice
>>>
>>> Thanks,
>>>
>>> Jeff W.
>>>
>>
>
>