S
steve
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?
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?