View Single Post
 
Old 08-22-2017, 10:52 AM
eduzs eduzs is offline Windows 10 Office 2010 32bit
Expert
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default Retrieve the last activated document name.

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.
Reply With Quote