Vba Excel to word; deleting all text from last bookmark to end of document

Try something like this...

Please Login or Register  to view this content.

Maybe something like this...

Please Login or Register  to view this content.

Remove the highlighted wdDoc maybe

Please Login or Register  to view this content.

Originally Posted by julhs

but couldn’t come up with solution to start FROM say line 2 after it.

It may depend on how you define "Line 2"
Are the "Lines" paragraphs? If yes, try this...

Please Login or Register  to view this content.

Originally Posted by julhs

Still the same with regards the selected/highlighted range.

“Lines” could be; just paragraph symbols; one line of text or a full paragraph

Not sure if at all relevant but it is counting from the top of the document and not from IN the Bookmark that it was pasted to.
Needless to say nothing is deleted, tried simply substituting “Select” with “Delete”, that just through a 5904 error.

Been wondering if problem lay with the copy&paste, and that it is not actually a Table, but simply a range of cells pasted in
from Excel, keeping the source formatting.

It works for my dummy Word doc. Can you post an example doc. ?

I used .Select for testing instead of having to re-type new lines in the Word doc. The .Delete and .Select should be interchangeable once the Range is workng.

I have lost track a little as to what errors there were, when and under what situation,
I am at the point of just not being able to see the wood for the trees.
So thought it prudent to upload the Job Book as well, chances are you will spot the problem immediately.
Any mention of “Invoice” just ignore it, is simply left over stuff not yet edited out.

Many thanks

julhs

Bookmarks are numbered in the order they were created and not in the order they appear in the Doc. You created WorkSheet_Template_insert_point as the 4th bookmark. Insert_point_4 is the 3rd bookmark created.

In the code, you could use the bookmark name instead of the bookmark index number e.g.

Please Login or Register  to view this content.

Each paragrah is the number of lines (empty ones as well) below the Bookmark.

I would think it would be easier to create a "Notes" bookmark at the line just below the Notes header and then use something like this...

Please Login or Register  to view this content.

Originally Posted by julhs

“Lines” could be; just paragraph symbols; one line of text or a full paragraph

Word doesn't really work with 'lines', which can vary from one PC to the next, depending on the OS version, Office version, what printer driver is active, and so on. Word works with paragraphs, tables, bookmarks, sections, etc. and can also work with manual line breaks.

From looking at your sample document and your Excel code, two fundamental flaws are immediately apparent:
1. You are simply re-using an existing document instead of creating a new one from a template (in Word, a .dotx file). If you were to create a new document from a Word template, you need have none of the problem tables to delete!
2. The way you're populating the document results in the content being inserted after the named bookmarks, instead of within their ranges. That's not entirely your fault, as some circumlocution is required to get the bookmarked range to expand to encompass what has been inserted. If you were to expand the bookmark ranges, you could then erase their content in preparation for whatever might be inserted. But, if you were using a template that started off without any tables, that's a non-issue.

From your code comments, it seems you actually want to delete everything from 'Notes' after the last table to the end of the document. That's quite easily achieved, though I don't know why you'd have the notes there if all you're going to do with them is to delete them before anyone gets to look at the document - unless, of course, they're from the last job, but that too wouldn't be an issue if you were using a template...

So, the solution to all these problems is: use a template.

Kind of like the tail wagging the dog - a mass of unnecessary code for its own sake, because all you're doing is addressing the symptoms not the cause.