Any difference between activating and opening a document?

L

Larry

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
 
J

Jezebel

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.
 
L

Larry

Thanks.

I've been eyeballing it, running two different macros, one that
activates an open document using the Activate method, and one that
activates the same open document using the Open method, and I don't see
any difference in speed. Therefore, there is nothing lost by using the
Open method in a macro as compared with using the Activate method.

However, though this was not my question, there does seem to be a
difference in speed between using the File menu to activate an open
document, and using the Window menu to open an open document. There's a
slight pause and flash when using the File menu. However, I may be
imagining the difference, and it may be due to the low amount of memory
on the Windows 98 Desktop (64 MB).

Larry


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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top