Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Deleting Files From VBA

As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default Deleting Files From VBA

Try using Kill

Kill("C:\My Documents\File I don't need.xls")

Dan E

"Brett" wrote in message ...
As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Deleting Files From VBA

On Error Resume Next
kill "C:\My Documents\Myfile.xls"
On Error goto 0

--
Regards,
Tom Ogilvy

"Brett" wrote in message
...
As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default Deleting Files From VBA

Brett,

Look up KILL in XL VBA help

HTH
Henry


"Brett" wrote in message
...
As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Not Deleting .tmp Files When Closing Ron Excel Discussion (Misc queries) 1 May 29th 08 10:22 PM
Deleting Files Ben Dover New Users to Excel 2 August 4th 07 04:03 PM
Deleting Files from within Excel acjas Excel Discussion (Misc queries) 4 December 15th 04 04:11 PM
Deleting Files from Within an Excel Macro Chad B Excel Programming 1 November 14th 03 09:38 PM
Deleting Shared Files???!!! Steven Revell Excel Programming 0 July 23rd 03 09:36 AM


All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"