Find and replace as footnote (from Excel)

Hi All,

I have an Excel routine that populates a Word template by searching codes and replacing them with the relevant text. This is working fine.

Embedded within the replacement text, I have additional codes that relate to footnotes - the Excel tool can correctly identify these codes, look up the relevant footnote text and add a new footnote with the correct reference and text. All good.

What I cannot get it to successfully do is place the footnote at the correct location in the body of the Word document. Currently, my best solution is as follows:

Please Login or Register  to view this content.

The problem is in correctly defining the location of the SearchCode within the body of the document - using the InStr() function doesn't work because this picks up all the nonprintable characters in the document, so the character count is never correct.

Any suggestions for how to get around this? Perhaps one of the following:

• Is there some way of me defining Rge in terms of an output from the .Find function?

• Alternatively, can I replace the SearchCode directly with the footnote?

• Or, instead, is there a simple way of identifying the accurate character count / insertion point for the replaced text?

Many thanks in advance,
AL

No, that doesn't work - just errors out...

Thanks though.

Just an update - I still haven't resolved this issue but I think i understand why it isn't working.

Please Login or Register  to view this content.

According to other sources, if this were being written in Word VBA (rather than via Excel), the Rge variable would actually be set as a Range, rather than as an object. At point [1] in the code, the scope of the Rge variable would then be redefined to start at the location of the found text.

This is not happening when the Object vartype is used, and i can't find any way of getting the Find function to return to the position of the found text.

Any ideas on how to do this from Excel?

Solved.

I think it was something to do with my use of braces {} - when I stop searching for a code bracketed in braces (e.g. "{1}") and switch instead to searching for a unique string ("REF01"), the Rge object correctly readjusts its scope and I can use that.

Weird.

Final code:

Please Login or Register  to view this content.

(Not: I have retained the braces around the unique code, hence needing to adjust the size of Rge at the end. When they are included in the search, the Find function doesn't adjust the scope of Rge.)