ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete the active wb (https://www.excelbanter.com/excel-programming/406134-delete-active-wb.html)

[email protected]

Delete the active wb
 
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

[email protected]

Delete the active wb
 
Nevermind,
I've used Ron de Bruin command and it worked perfectly

Kill strOrigDir & strCurrentOrigFileExt

thanks Ron


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com