Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |