Replies

Understand Paul and thanks for the reply. I think I would take whatever macro I could get and run it anyway, as it will give me something that I can use (even if partial).

Hello again,

Here is some additional clarification on what the macro needs to do:

1. Search through a 300 page MS Word document.
2. Find all letters not numbers in parenthesis from say 2 – 10 characters in length.
3. Take the number of words preceding the parenthesis that correspond to the number of letters inside the parenthesis.
4. Output a list with the letters in parenthesis first (without the parenthesis now) followed by, for example, two spaces and then the words that had originally come before the parenthesis.

In other words, the macro finds the first word/term combination: Chief Executive Officer (CEO)

The macros sees three letters in parenthesis and three words before the parenthesis.

The macro outputs the following to a list:

CEO Chief Executive Officer

The macro loops through and finds the second word/term combination: Vice President (VP).
We see two letters now in parenthesis and two words before the parenthesis.

The macro outputs the following to the same running list:

VP Vice President

The macro loops through the document until all terms in parenthesis (for example 1-10 letters which correspond to 1-10 words) are captured and outputted
in the desired format with term first followed by term definition.

Note: The document is currently setup with acronym definition first followed by the acronym term in parenthesis – e.g. Director of Operations (DO). In this case here, I would like to filter out words like: a, of and others and just stick to just the term and acronym term acronym definition – if possible.

Please let me know if a macro like this is possible, as well as ideas on how one would make this work.

Thanks in advance for your input.

Regards,

Jim

Thanks Jweissmn1,

I appreciate the link to the macros from Paul Beverly.
I will certainly check it out as well.

Regards,

Jim

Thanks Paul.

I really appreciate the reply. I will check out the links.

Regards,

Jim

Thanks for the reply Andrew, and the macro. I really appreciate it.

I see the Macro Code you provided does work in a protected (locked down styles driven) template, but you must highlight the numbering field (e.g. 4) you want changed and then run the macro.

This works great, but I am looking to have a specific style from the styles window, which can restart/reset the list numbering after a new Heading 1 (e.g. Chapter 2) and same hopefully
for at least for heading level 2 and heading level 3. Is this possible? I tried one approach I found on the web by Defining Multilevel Lists with:

Heading Level 1 – N/A
Heading Level 2 – restart list after Level 1
Heading Level 3 – restart list after Level 2
and so on

But, it did not work.

Attached, is a quick template I created.
I highlighted where the list level is at number 4 – where it should reset to number 1 again.

The password for the sample template is: Test

It sounds like I need to merge headings and list elements into the same outline list, as you said, and I believe I may have attempted that, but with no luck.

Please look at the attached document and check out the MultiLevel List, if you can.

Thanks for any feedback you can provide on this question.

Regards,

Jim

HI Zeddy,
Thanks for the reply. This sample you sent is fantastic. I tried adding a quick new made up entry and set it to Y and it came in green.
This is very nice indeed. I will look at it in more detail when I have a free moment. My overall goal is to get away from doing this manually in Visio – especially
when all the data is in Excel and Excel can be automatically created in tree format.

My next, question deals with adding branches (sub-branches) off the main branch. Also, what about the main root (top) of the tree. How can that be added in on the tree tab? See attached and thanks once again for looking at this. It looks really nice.

Jim

Thanks Paul!!! It works great.

Thanks for the tip Abraham. I will check it out.

Jim

Hi Paul,

Thanks for the posting and my apologies for the delay in getting back to you – work has been incredibly busy.
I will give the code out when I get a moment.

Thanks again for taking the time to post this.

Jim

Thanks Andrew. I ran a search earlier, but I guess I did not have the right keywords. I will check the thread you referenced.

Thanks,

Jim

Paul,
So, it looks like I would have to put a unique bookmark in each of the 200 documents first (either through some macro – if possible or manually), in the footer or header. And it looks like linking to

{PAGE

* MERGEFORMAT}/2 [/B]might be good in one place where the destination link is for page 1 in a certain document, but not in another, since the destination link may be on page 2 in another case. So, bookmarks are probably the most reliable away to make this happen. I will look into that further. -J

Paul,

Honestly, I never thought it would be this difficult to get a macro. I am about ready to give up on the whole thing. It would seem (at least by you) that I have presented too much information in this posting. So, I will try one last time to post what I am looking for in a new macro. If it can’t be done, then tell me and I will end the discussion on this topic here and now (although, the only opinion I have received to date, is from you).

Okay one last time, I would like to find a macro that:

1. Points to a folder full of MS Word 2010 documents (this we know already).
2. Finds a numeric link of six numbers such as: 0100 00 (the format is always the same, starting with a zero, three digits, a space and two digits).
3. Searches other documents (in the page header or footer only) for the same number, and then establishes a link.
4. Repeats steps 2and 3 until all numbers in the body of all the documents have links established.

As for the destination link, yes I agree there can be several header and footer pages, which is why I thought maybe it could link to perhaps a specific footer, such as in page 1, which would contain: ‘{PAGE * MERGEFORMAT}/2 . Maybe the code could say, find the first corresponding reference in a footer and link to it.

Overall, maybe this is not possible to do in MS Word. I am not sure, but since no one else has responded to this post, I am guessing that it’s probably not possible to effectively do this in Word.

Thanks for the input.

Jim

Hi Paul,
I appreciate your comments about PDFs, but what I am really focused on right now, is finding and linking to keypoints in a header or footer. In theory, I think that is possible to do, I just need to know how to make Word search for a number inside of a footer or header. It could even be a hidden text style or a bookmark that is embedded in the header or footer. That is what I want my origination link to find when it searches through documents. The PDF is another issue and I have other ideas for the MS Word document. Right now my focus is on finding a macro code that can execute that search. If I knew how to do that, I would not be asking it here in this forum. Thanks anyway. Jim

Hi Paul,

Yes of course I can reuse the same code from the graphics macro (looping through a folder full of documents). My posting here is really focused on finding the wildcard listed above and linking it to a page header or page footer destination link (another document) when it finds the target. I don’t think that segment of coding has been brought up before, at least not that I reckon. Thanks, -J

Hi Paul,

I did not see a PM from you on this. Let me go look for it. Thanks,

Jim