Delete the active wb

  • Thread starter Thread starter Avassiliadi
  • Start date Start date
A

Avassiliadi

Hello all,
The last touch to my macro is to delete the log file from which I've
extracted the infromation and then saved as a text file.

Here is the command I use:

Sub DeleteOrigFile()


Workbooks(strCurrentOrigFileExt).Delete


End Sub

Do you need more info?

Thanks
 
Nevermind,
I've used Ron de Bruin command and it worked perfectly

Kill strOrigDir & strCurrentOrigFileExt

thanks Ron
 
You must log in or register to reply here.

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

runtime error 9 in my macro 2
Code to delete names works in one WB, but not another WB? 2
closing another file by code causes failure to run workbook activate event 2
Getting the name & path of a hidden WB 2
Delete WB 4
help with VBA program to import and add formatted files to one file 0
All Workbook Saved except This Workbook 3
Worksheet toolbar 6

Back
Top