stretch66 Racing towards the start Local time Today, 12:56 Joined Sep 28, 2005 Messages 72 Jan 18, 2007 #1 Hi, Using code in Access how is it possible to delete an Excel File. Have tried the Kill statement but cannot get it to work. Any advice greatfully accepted!!!
Hi, Using code in Access how is it possible to delete an Excel File. Have tried the Kill statement but cannot get it to work. Any advice greatfully accepted!!!
L llkhoutx Registered User. Local time Today, 06:56 Joined Feb 26, 2001 Messages 4,018 Jan 18, 2007 #2 Use the Kill command to delete any file. You've got to have to path. If no path is given, it might assume the same folder your mdb is in.
Use the Kill command to delete any file. You've got to have to path. If no path is given, it might assume the same folder your mdb is in.
M Moniker VBA Pro Local time Today, 06:56 Joined Dec 21, 2006 Messages 1,567 Jan 19, 2007 #3 You can have a user browse for the file using a FileDialog object. Search this forum for FileDialog, and you'll see examples of how to set up the file dialog, the required reference, etc. That way, you can guarantee the correct path and filename.
You can have a user browse for the file using a FileDialog object. Search this forum for FileDialog, and you'll see examples of how to set up the file dialog, the required reference, etc. That way, you can guarantee the correct path and filename.
