So just to be clear you have 3 files to deal with. The one that is running
the code. Another one that is active and finally a new one that you are
opening/selecting?
--
HTH...

Jim Thomlinson


"Steven" wrote:

I have a macro that opens a file and then goes to that file making it the
active window. I then want to go back to the previous file but not tuse the
name of the file because the file it goes back to can be any file (ie it will
not always be the same file.) How do you programmatically go to the last
window open without using the file name.

Thank you,

Steven