![]() |
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 |
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