Code to copy Excel data to a Word document
Hi All,
If possible could someone please tell me why the below code is not calling the normal.doc macro "testy" and any solutions
The code opens a new document, pastes the text from the clipboard and then fails to run the wanted macro.
Any help is appreciated
Cheers
Please Login or Register to view this content.
Last edited by Zimbo; 04-09-2009 at 03:31 AM.
Hello zimbo,
It isn't clear to me what you are doing. Is "testy" a macro in another Word Document or is it the data on the clipboard that you have pasted or something else? Whenever you encounter an error, please include the error number. Include the error message too, if you can.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
The method works fine for me. Comment that line out and check that your Normal.Dot's Module1 testy sub exists.
You could add a Normal.dot Module1 Sub Hi to test run.
And then change your Run in the Excel code to:Please Login or Register to view this content.
Please Login or Register to view this content.
Zimbo,
The name of your macro is not a suitable thread title. Please read the forum rules about thread titles, and then amend your post accordingly.
Entia non sunt multiplicanda sine necessitate
Hi Leith,
The macro creates a new word document and then dumps the clipboard into this document. The "testy" macro is located in the Normal.doc document and is is designed to format this new Word document.
Appologies on not mentioning the error.
The error being received is:
CheersPlease Login or Register to view this content.
Re: Code to copy Excel data to a Word document
Hi Kenneth,
I have tried your code which does the same as mine in a fresh workbook and word document to see if I was going crazy and it is still coming up with the error code mentioned in the above post.
Help Please
Re: Code to copy Excel data to a Word document
Hi All,
I have removed the reference to the Normal and Module 1 in the word call section and it now works perfectly.
Thanks for the helpPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks