View Single Post
  #2   Report Post  
Jezebel
 
Posts: n/a
Default

In principle, activating means switching to an open document, while opening
means read (or re-reading) from disk. In the case of Windows menu vs. File
menu for a document already opened, yes there must be some difference
because selecting an open file from the file menu takes longer.

In respect of VBA, the obvious difference is that opening the document
(whether or not already open) does not activate it.






"Larry" wrote in message
...
Is there any practical difference between activating an open document by
clicking on its button on the Window menu, and "opening" the already
open document by clicking on its button on the File menu? Is the latter
method slower and less efficient?

Similarly, to activate an already open document from a macro, is there
any difference between

Documents([DocName]).Activate

and

Documents.Open (DocFullName)

Will the macro work less efficiently if I do the second approach?

Thanks,
Larry