| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting file while in use
Hey guys
The Excel file I am trying to delete is the same file that the code is in. I know it is impossible to delete or overwrite an Excel file that is in use by Excel. But is there anyway that after Excel quits, it can delete itself? Thanx Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting file while in use
Look at the
ChangeFileAccess method. Have your code change it to readonly , then try to delete it. I haven't tested it, but it might work. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... Hey guys The Excel file I am trying to delete is the same file that the code is in. I know it is impossible to delete or overwrite an Excel file that is in use by Excel. But is there anyway that after Excel quits, it can delete itself? Thanx Todd Huttenstine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting a file | Excel Discussion (Misc queries) | |||
| deleting a file | Excel Discussion (Misc queries) | |||
| Deleting a file from within Excel | Excel Worksheet Functions | |||
| Deleting a file on C drive using VBA | Excel Programming | |||
| Deleting a file using VB | Excel Programming | |||
Hybrid Mode
