Why I can not copy from a invisible document?

[Jing You]

hi, everyone

I am trying copy something from a hidden document to an opened document.
But I got nothing.

My code opening a hidden document like this:

'------------------------------------------------

Documents.Open FileName:=FileName, ConfirmConversions:=False, ReadOnly:=
_
False, AddToRecentFiles:=False, PasswordDocument:="",
PasswordTemplate:= _
"", Revert:=False, WritePasswordDocument:="",
WritePasswordTemplate:="", _
Format:=wdOpenFormatAuto, XMLTransform:="", Visible:=False


afther the code, I do the copy operation like this:

Selection.WholeStory
Selection.Copy

But nothing was copied to clipboard. How can I get the correct way?

Regards,
Jing You

 

[Jezebel]

The problem is the use of the Selection object: you don't actually select
anything, which is just as well since your document is invisible. In any
case, you're better off avoiding the Selection object in VBA, and you rarely
need it except for interacting with the user. Try it like this:

Documents.Open (FileName:=FileName, ...).Content.Copy

 

[Jing You]

After some tests for the problem, I got the answer.

If a document is an invisible document, it should be initialized as an
inactive document. So we need call "document.active" method to active the
docuemnt, then all operations to this document are effective.

 

[Jing You]

hi, Jezebel

Thank you! Your advice is quite well.

Regards,
Jing You

 

[Jezebel]

That will work, but it's not a good approach.

After some tests for the problem, I got the answer.

If a document is an invisible document, it should be initialized as an
inactive document. So we need call "document.active" method to active the
docuemnt, then all operations to this document are effective.

 

[Howard Kaikow]

As Jezebel stated, get used to using the Range object instead of the
Selection object.
In general you will end up with faster and cleaner code.
Use Selection object only when there's no other way to do the deed, or in a
quickie piece of code.