Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |