VBA to Push Excel Table to Word

Hello, I have the following code that runs from within Excel to copy and paste a table in to Word between 2 bookmarks. I have to do this from Excel to Word as the company security protocols block running VBA in Word files.

As the code stands it works and I'm sure there are ways in which is can be improved but the issue I have is that it doesn't work for everyone and in theory we all have the same build of corporate laptops. I'm at a loss as to what might be causing the issue. At first some did not have the "Microsoft Word 16.0 Object Library" enable in Excel and this fixed 1 or 2, but some are still getting;

Run time error 4068 - Value out of Range

If debug is clicked it highlights the following line

wdDoc.Range(rngStart.End + 2, rngEnd.Start - 2).Delete


Now I've watch someone do this and I know they are using the right Word file with the bookmarks in, so very confused.

Many thanks for any tips or guidance as to where to look next, as I still think it a PC issue, due to the code working on other PC's



The full code

Please Login or Register  to view this content.

@Artik

Administrative Note:

Sorry, but your post does not comply with Rule #9 of our Forum Rules:

The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.

Instead of bookmarking two ranges and trying to past a table between them, you should simply bookmark the range you want to paste the table into.

The following code assumes you want to paste the Excel table into a bookmarked Word range named "RAID":

Please Login or Register  to view this content.

Originally Posted by richard.venn

the reason I have it pasting between 2 bookmarks is that I want them to still be available after the paste, as there might be reason to run the macro again after updates to the RAID. Just wondering if a single bookmark will remain after the paste?

If you look at the code (or even just the document after running it), you will see that the bookmark is still there after the code finishes.