It depends on how you "go to" that file. Say we have Book1 and Book2 open
with Book1 being active. This macro:

Sub gothere()
Application.Goto
Reference:=Workbooks("Book2").Worksheets("Sheet1") .Range("A154")
End Sub

will "goto" a specific place in Book2. Now lets say we want to return, but
have not remembered where we came from. We just want to go back. All we
need to do is:

Sub goback()
Application.Goto
End Sub

Excel keeps a stack of the places we visit if we have a chain of "gotos".

Application.Goto
without an argument is like the back arrow in IE.
--
Gary''s Student - gsnu200772


"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