Thread
:
Deleting a file from within Excel
View Single Post
#
4
Night Owl
Posts: n/a
Thanks, William.
I'm sorted,
Pete
"William" wrote in message
...
Hi Pete
Sub test()
'Assumes full path of file name
'to be deleted is in cell B2 and
'the file has been closed
Dim myFile As String
myFile = ThisWorkbook.Sheets("Sheet1").Range("B2")
Kill myFile
End Sub
Sub test1()
Application.DisplayAlerts = False
ThisWorkbook.Sheets("Sheet1").Delete
Application.DisplayAlerts = True
End Sub
--
XL2003
Regards
William
"Night Owl" wrote in message
...
Hi,
I'm importing data from an external *.txt file, but don't want to
duplicate the data by importing the same file twice. When I'm doing it
I'll remember to delete the file after I've imported it, but when someone
else does it they may not.
So my question is this...
The filename and path are stored in the variable myFile - How can I
delete this file as the final step in the macro, without being prompted
by a yes/no option?
As an aside, I also get a prompt when I try to delete a non-active sheet
using code. Can I prevent that, too?
TIA,
Pete
Reply With Quote