Deleting document from pat

[JohnCarterJr]

I need to know how to delete a spread sheet from a folder (using my macro).

I have a macro/vba that takes data from spread sheets that are sent to me by email. The spread sheets are saved an "in process" folder. Once I run my macro (and the data is extracted from the spreadsheets and copied onto my main database), the macro moves the document to a "completed" file. How do I make my macro delete the file in my "in process" folder?

Thanks!!

[mrice]

You need to use the unfortunately named Kill (Pathname) statement to delete. Alternatively use the Name path1 as Path2 statement to move the file as opposed to copying it.

[JohnCarterJr]

I'll give it a try. Thank you Pat.