Replies

The added code works fine. Now the TOC, LOT, and LOF are all updated with one click. Great macro to keep. Thanks, Hans

In my test file only the TOC updated with your macro. The LOT and LOF did not.

Is there code that can be added to this Update TOC macro to also update the List of Tables and List of Figures?

No compatibility options were selected on the affected computer I tested.
I don’t think the printer settings are set to Hidden Text, but how do I check that?

Thanks, Hans. Your one line of code to update the TOC worked and I prefer it to the macro I recorded.
Nobody here has any idea why the document appears differently to different people, either.

I have attached the ExportComments macro with all of the modifications.

I can survive without the paragraph heading column. You’re right about the Scope text not applying to tracked changes, but it’s really what I needed for Comments (I had to add a line to create the column header). Your macro is going to save a lot of time for my department – I appreciate all of your effort.

Thanks for all of your input, Jefferson. Fortunately the number of roman numeral pages my document have is not enough to worry about.

I also had to change PageNumber to AdjustedPageNumber in the cmntNext statement. Now the macro exports the page number that appears in the footer, which is what I had asked for. Thanks, Jefferson! Is there any way to preserve the format of the page number (the roman numerals i, ii are appearing 1,2)?

My page number in the footer uses the standard {PAGE} code.

The macro works, but I’d like three modifications if possible:
1. Instead of Section number, the heading number (e.g., 3.2.1.5) under which the comment/change is located (or the lowest heading number if it spans multiple heading numbers).
2. Instead of the “overall” page number, the page number that appears in the footer where the comment/change is located (or the lowest such page number if multiple pages).
3. The contents of the “target” (the selection upon which the comment/change is applied) of the comment/change. If it’s an image, export “Image” to the spreadsheet. If it’s a table, export “Table”. I realize that a limitation to the size of the selection would be required (say the equivalent of 15-20 words) in case the target is large.

I don’t see a Tools>References. I do have Tools>Look Up Reference, which gives me only a Bookshelf 2000 option.

Thanks, Stuart. I’m getting a “Compile Error: User-defined type not defined” at Dim xlApp As Excel.Application

I have only created simple macros, edited recorded macros, and pasted in the code of others, so I need help with pretty much all of the items you listed.

Thanks for trying, guys. I especially appreciate the link to the WordTips website that I wasn’t aware of. Microsoft must have changed from black to gray bookmark brackets to make it interfere less with regular black text. They didn’t consider the confusion they would cause by blending into standard shaded fields.