Password setting and Error 424

Dear all,

I have 2 documents. The vba below is used to copy the contents of table in doc1 and paste it in table of doc2 and then set password for doc 2.

I got error code 424 object required at this line:

Please Login or Register  to view this content.

And password of the document 2 could not be set.

Please Login or Register  to view this content.

Full code:

Please Login or Register  to view this content.

Could anyone advise? Thank you!

I think you might be confusing applications and documents.

You've got two applications, wdApp1 and wdApp2, whereas you probably really only need one instance of Word.
If Word is already running then these would likely both point to the same instance of Word anyway.

Please Login or Register  to view this content.

You have two variables for the documents wdDoc1 and wdDoc2.
However, if Word isn't already running then, instead of being documents these are actually two separate application instances.

Please Login or Register  to view this content.

Maybe something along these lines

Please Login or Register  to view this content.

Dear Bytemarks,
It worked perfectly. Thank you so much for your advice! Really appreciate your help. Thank you!

However, password could not be set still.

Dear all,

I still could not figure out the password setting part, the revised code (running from excel) after ByteMarks remarks above is as follows, the code could be run smoothly to copy contents from plan.doc in lesson plan folder to report.doc (attached here) in the same folder as the macro without setting password.

Any advice is appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi,


Looks like the 123 in Password:=”123” has smart quotes rather than "proper" quotes. Maybe that's the reason?

Hi ByteMarks!!!!

I got it. The existing password will only protect the document setting password for Tracking changes (revisions) . I have to change the code=

Please Login or Register  to view this content.

. In this way, the whole document would be protected and need "333" to open the document which is what i wanted.

Thank you so much for your help!!!!!

That's great. You're very welcome.