deleting a file through VBA

P

pat67

Hi, I am trying to delete a file using VBA. Here is the situation. I
have code that opens a file, called say ABC. The code then makes
changes that I have specified and at the end saves the file as ABD
( dd-mm-yyy). What i am trying to do is have the code then delet the
original file as well since there is no longer a need for it. Anu
ideas?

Thanks
 
P

pat67

Hi, I am trying to delete a file using VBA. Here is the situation. I
have code that opens a file, called say ABC. The code then makes
changes that I have specified and at the end saves the file as ABD
( dd-mm-yyy). What i am trying to do is have the code then delet the
original file as well since there is no longer a need for it. Anu
ideas?

Thanks
Click to expand...

Never mind I found the Kill code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Word VBA for deleting Selected Row 0
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Run-time error 1004: Unable to set the left property of the OLEObject class 0
Excel How to activate already opend PDF file through VBA code 1
Forcing a date entry format of dd/mm/yyyy 1
Collapsing all groups 0
Excel VBA - counting cells by colors and names to it in two different rows. 0

Top