Copying data's from Excel to Word throwing a run time error

[GirishDhruv]

Hi Everyone,
This is my first post, please do help
Here i have tried with some data that should be added from Excel to Word, later convert from Excel to Word and Good thing is that below code runs, but after executing with some sheets it throws me a run time error and code exits

Think i have some 40 records and if i run the below code i am getting these Errors
>On the word document '6' , my code is delayed more
>After 10th or later, word document its throwing me the run time error 4605.
Can anyone help me to solve this out

Below is my code

Please Login or Register  to view this content.

From the above code mainly in the highlighted lines it throws me error

Thanks in prior

[alansidman]

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

https://www.mrexcel.com/forum/genera...ime-error.html

[mjr veverka]

... From the above code mainly in the highlighted lines it throws me error ...

1. Constants from "Word" of type "wdPasteText, wdAlignParagraphLeft, etc." are not directly supported by code running from excel.
The fact that they work at all from the level of excel is due to the flexibility of the compiler.
However, they can generate execution errors, so you should first declare them with the appropriate values

2. Attach an example, resulting ".doc" file with the correct paragraph layout (of course, do not enter real data there)

3. The ".xls" file would also be useful (of course with false data)