Deleting a file with Excel?

neo · Mar 7th, 2002, 07:34 AM

is there a way with excel 2000 to delete a file? i have a workbook that keeps updated records throughout the week. on monday, the first data is calculated. then tuesday a new copy of the book is opened and it gets tuesday's data, adds it to mondays data, and now there's an updated record in one place. wednesday, a new one is opened that adds the monday/tuesday data to it, so on and so forth. what i need is for the previous days workbook to be completely deleted as the users have strict disk quotas to meet.

can this be done through automation?

tia (c:
neo

Anne Troy · Mar 7th, 2002, 08:11 AM

kill filename.xls

Mar 7th, 2002, 08:11 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	kill filename.xls __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 07:34 AM	#1
neo New Member Join Date: Mar 2002 Location: Birmingham, Al Posts: 19	is there a way with excel 2000 to delete a file? i have a workbook that keeps updated records throughout the week. on monday, the first data is calculated. then tuesday a new copy of the book is opened and it gets tuesday's data, adds it to mondays data, and now there's an updated record in one place. wednesday, a new one is opened that adds the monday/tuesday data to it, so on and so forth. what i need is for the previous days workbook to be completely deleted as the users have strict disk quotas to meet. can this be done through automation? tia (c: neo