Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Thu Jul 15 14:13:22 CDT 2004
Greg, You can use the Kill statement. or You can use the DeleteFile Method of the FileSystemObject. Mark -----Original Message----- From: Greg Smith [mailto:GregSmith at starband.net] Sent: Thursday, July 15, 2004 2:54 PM To: accessd at databaseadvisors.com Subject: [AccessD] Delete an external file from within Access vb Hello again. Many thanks to Charlotte, Mark, Rocky, Dan, Max and Gustav for your help on the "open file dialog" box issue. It works! Now, I want to delete the file that 'we' used after selecting it from the file dialog box. I don't want to delete it right after selecting it, but later, after I've imported the data that was in it. But I can't remember how to do it. I know I've done this before but I can't find the code nor the brain cell that contains that information...it might be on vacation at the moment. Or it's fighting with the only other one I've got. Or they're both out playing HALO and I'm toast. Any help would & is greatly appreciated. Thanks! Greg Smith gregsmith at starband.net -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com