-
How to Paste info from an Excel Macro into a new word document
OK, I have written an Excel macro that creates a String. I want to take that String and copy it into a new word document. I can open a new word document using
Application.ActivateMicrosoftApp (xlMicrosoftWord)
but I don't seem to be able to access the document from the excel macro to copy the information.
Is there a simple way to do this? Does some one have some sample code to show me?
Thanks in advance.
PNJ
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules