Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete File in a folder
Hi all, i save a file to a folder using a certain name and after i have
finished with it and closed it i need to delete it. I have played with some code but just cannot get it to work. Could somebody help me out of my misary please !! Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete File in a folder
Set fs = CreateObject("Scripting.FileSystemObject")
Set obj = fs.GetFile("your-file-name") obj.Delete "Les Stout" wrote in message ... Hi all, i save a file to a folder using a certain name and after i have finished with it and closed it i need to delete it. I have played with some code but just cannot get it to work. Could somebody help me out of my misary please !! Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete File in a folder
If you want to use the built in VBA capabilities:
Kill "C:\MyFolder\MyFile.xls" -- Regards, Tom Ogilvy "Les Stout" wrote in message ... Hi all, i save a file to a folder using a certain name and after i have finished with it and closed it i need to delete it. I have played with some code but just cannot get it to work. Could somebody help me out of my misary please !! Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete File in a folder
Kill full_filename_including_path -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Les Stout" wrote in message ... Hi all, i save a file to a folder using a certain name and after i have finished with it and closed it i need to delete it. I have played with some code but just cannot get it to work. Could somebody help me out of my misary please !! Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete File in a folder
Thanks Bob and Tom, have a great weekend.
best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time based file/folder delete | Excel Discussion (Misc queries) | |||
Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
open file from folder save in new folder | Excel Programming | |||
Create Folder and Text File in folder | Excel Programming | |||
fso delete folder | Excel Programming |