deleting word bookmarks from excel - change to existing code

[excelor100]

Hi,

I have some code which is working perfectly within excel to paste data into word. I'm now just looking to add deletion of bookmarks at the end of the code, so the last process undertaken after the data has been pushed into word is that the bookmarks are deleted (Not the text, just the reference point).

I've found some bookmark deletion code which works in word (and it keeps the text) and done some researching but can't find how to add it and get it working. Hopefully this will be an easy one for your expert standards!

Any help greatly appreciated.

Please Login or Register  to view this content.

and here is the bookmark deletion code that deletes the bookmark but not the text

Please Login or Register  to view this content.

[danielexcelvba]

I'm not sure how to get excel to recognize bookmarks, but if putting a macro in your word doc is an option, you could add this code in your macro

Please Login or Register  to view this content.

where "Test" would be a macro in your word doc corresponding to

Please Login or Register  to view this content.

[xladept]

Maybe:

Please Login or Register  to view this content.

[xlnitwit]

@xladept,

It appears that the code is late bound, so you need to declare the variable as Object

Please Login or Register  to view this content.

[macropod]

Is there a particular reason you need to delete the bookmarks? Empty bookmarks, for example, are of no consequence (and that's precisely what yours remain). Do note, too, that any cross-references to other bookmarks you may have will generate errors if their bookmarks get deleted...

[excelor100]

@xladept and xlnitwit - thanks for your responses. I have tried the code Xladept but I get the error 'user-defined type not defined'

@xlnitwit - I changed the declaration of the viarable as you stated

Please Login or Register  to view this content.

but then I get error no.438.

If you get the chance to look over it again, would be hugely grateful.

As I mentioned the original code I pasted works perfectly and does exactly what I want, other than delete the bookmarks at the end.

I am able to run a separate macro in word to get rid of the bookmarks (the one I posted), but then that requires manual intervention which obviously I want to avoid using the macro.

Thanks!

[xlnitwit]

Change the loop to read thus

Please Login or Register  to view this content.

I would also second macropod's comment.

[excelor100]

@danielexcelvba - thanks for taking the time to reply, I have a word macro already which I used to test the concept of deleting word bookmarks (but not the text), but thank you!

@macropod - yes there is a particular reason, being the person who will get the final document does not like bookmarks so it's a top secret mission so to speak

[excelor100]

Change the loop to read thus

Please Login or Register  to view this content.

I would also second macropod's comment.

That works perfectly thank you!

Really appreciate your time and everyone else's to assist me.

Hopefully you saw my reply to macropod, I am aware I can just amend the word document so the bookmarks are not showing, but in this case the recipient does not want bookmarks to be used for their documents. Although there is no issue in me using them. This way I can send the document without manually deleting each one.