| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete the active wb
Nevermind,
I've used Ron de Bruin command and it worked perfectly Kill strOrigDir & strCurrentOrigFileExt thanks Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete cells not in Active Worksheet | Excel Programming | |||
| Delete all sheets except the active one...? | Excel Programming | |||
| How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
| Unable to delete Active worksheet | Excel Programming | |||
| Delete (Kill) Active Workbook | Excel Programming | |||
Linear Mode
