| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close specific workbook
I have one workbook that has a macro that imports a .txt or .dat file,
processes it then saves it to a specified location. At the end of the macro, I tried closing the ActiveWorkbook but that ended up being the 'new' file I created. How do I close the 'source' file (the filet that is running the macro)? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close specific workbook
try Thisworkbook.Close
"Robert_L_Ross" wrote: I have one workbook that has a macro that imports a .txt or .dat file, processes it then saves it to a specified location. At the end of the macro, I tried closing the ActiveWorkbook but that ended up being the 'new' file I created. How do I close the 'source' file (the filet that is running the macro)? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close specific workbook
DOH! Genius!!
Thanks! "Joel" wrote: try Thisworkbook.Close "Robert_L_Ross" wrote: I have one workbook that has a macro that imports a .txt or .dat file, processes it then saves it to a specified location. At the end of the macro, I tried closing the ActiveWorkbook but that ended up being the 'new' file I created. How do I close the 'source' file (the filet that is running the macro)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Close a specific workbook. | Excel Discussion (Misc queries) | |||
| Open New Workbook / Save and Close Current Workbook | Excel Programming | |||
| Close specific workbk | Excel Programming | |||
| How to close specific workbook not all active workbooks? | Excel Programming | |||
| Excel VBA-How to close all open workbooks except one specific? | Excel Programming | |||
Hybrid Mode
