[sword-devel] More VBA Help Wanted

[Troy A. Griffitts]

I have another opportunity for someone with VBA skills:

Big picture:

A professor of OT at Phoenix Seminary who a huge library of documents 
with Hebrew text embedded throughout.  He has used a custom bitmap 
Hebrew font for a number of years to do all of his work, and want to 
migrate all of his data to Unicode.

He uses a Mac with OSX
Microsoft Word
Microsoft Powerpoint

I'm hoping we can do something like:

Walk the document structure, and look for any text with the font 
specified as his custom Hebrew font, change the font name to SIL Ezra or 
similar free Unicode font, and translate the encoding to Unicode.

Does this sound feasible?

He is building me a document that looks something like:

a	ALEPH
b	BET


where the first column is the custom Hebrew character in his font (is 
overlaid across the standard lower ASCII range, and will appear probably 
as: a, b, etc.)

With this data we can build the Unicode translation table.

My hope is that VBA will allow us to provide a plugin macro for his 
office suite where can can just open a document and run the macro and 
have the strange Hebrew encoded text in his current document converted 
to Unicode and a new font.

What do you think?

	-Troy.