How to retrieve value of the bookmarks from the word document

Then you'll need to test the excel cell value for nothing and delete the corresponding bookmark.

Not tested.

Please Login or Register  to view this content.

Or you could setup your document with the entire sentence in a bookmark, then have a bookmark within that to change the value. Then you could just delete the sentence bookmark without having to expand the value bookmark.

Ok I find the A is integer that starts from lastrow to 2 step wise. But I get Byref argument type mismatch error. And it points to red line that i have highlighted.

Please Login or Register  to view this content.

Is A greater than 1?

Or is lastrow > 2.

This code is really incomplete. You'll need to 'flesh it out'.

If you need help with that, provide a few details about the data in Excel. Where the data located, etc. Is it all in a column, or spread out around the sheet?????

Ok. I still couldnt find a solution for that. I have attached a sample excel sheet and its word document template. the data is located in "data" sheet with row 1 as column number, row 2 with bookmark name,row 3 column name and from row 4 onward there is data. the "setup" has the column number, bookmark name and description of bookmarks. the third sheet is "codeinfo" has the template name and destination folder where the reports are to be saved. Please help.

OK, so you've discovered Word's dirty little bookmark secret. When you insert text using the bookmark, it replaces the text AND THE BOOKMARK. So the bookmark gets deleted. Then, when you iterate the newly created document for bookmarks, there isn't any. That's why the code isn't working. (Because the code works in Word before the bookmark replacement.) You can read about the workaround here.

Sorry, that I can't spend more time on this, but I've been called out of town and don't know if I'll get back to it soon.

I still think you should create blank bookmarks and add the entire phrase in the bookmark instead of the current setup. Then you only have to 'touch' the bookmark once. So, instead of replacing the XXX with For, have an empty Bookmark named VoteNxt, and replace it with Vote for next year: For. If the value of the bookmark is empty (in the excel sheet), then just skip it.

Good luck.

hi Tinbendr, nice to hear from you. As you have specified now I am trying to have the whole sentence as bookmarks so that if there is no value from excel I will just get a blank line. Thanks for the idea.

It's very difficult to delete pages in Word. It's always better to start with less and add in. In Excel, everything is exact, but Word in fluid and moves around a lot, thus making it difficult to delete objects with any certainty.

I have an attachment (fancy table) that I use in my work, but I don't need on every report. So I created an Attachment.doc and 'InsertFile' whenever I need the table. I had much more success adding a page than trying to delete the second page.