Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleting a file from within Excel
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 |
#2
|
|||
|
|||
Try
Application.DisplayAlerts=False 'Your Filename'.Delete Application.DisplayAlerts=True Regards, Alan. "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 |
#3
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
2003 Excel isn't reading the book.xlt file on startup. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel |