| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing a txt file open in xl
I have a sub in my personal macro workbook that is
suppose to close a txt file I have open in xl. The txt files name is set to the variable uardbalfile. I try the below statement and xl crashes Windows(uardbalFile).close So I try this (my txt file is the active file) ActiveWindow.Close When I execute this statement, before the execution is complete, my txt file is deactivated and another workbook that I have opened becomes active, so xl closes my other work book not the txt file. What am I doing wrong, any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
closing a txt file open in xl
Hi
try workbooks(uardbalFile).close -- Regards Frank Kabel Frankfurt, Germany "steve" schrieb im Newsbeitrag ... I have a sub in my personal macro workbook that is suppose to close a txt file I have open in xl. The txt files name is set to the variable uardbalfile. I try the below statement and xl crashes Windows(uardbalFile).close So I try this (my txt file is the active file) ActiveWindow.Close When I execute this statement, before the execution is complete, my txt file is deactivated and another workbook that I have opened becomes active, so xl closes my other work book not the txt file. What am I doing wrong, any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how i open another sheet in the same workbook without closing? | Excel Discussion (Misc queries) | |||
| Open each file in a folder and closing it | Excel Discussion (Misc queries) | |||
| Excel program remains open after closing file | Excel Discussion (Misc queries) | |||
| closing file with multiple windows open | Excel Worksheet Functions | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Hybrid Mode
