Is there a way to retrieve the last activated document name?

For example:

I have 3 opened documents:



Doc1, Doc2, Doc3.

Within Doc2 I call a macro that will open Doc4, with Doc4 I need to retrieve the last activated documente name (Doc2, not Doc4 which is the current activated document).

Thanks.

__________________
Backup your original file before doing any modification.