[sword-devel] More VBA Help Wanted

Keith Ralston sword-devel@crosswire.org
Wed, 10 Dec 2003 22:57:41 -0600


Send me the information when you get it.  I took my last final for the
semester today.  Yipee!!

I will get back to work on Mark.

Has anyone done anything with the other VBA macros beyond the installer?

> -----Original Message-----
> From: sword-devel-admin@crosswire.org
> [mailto:sword-devel-admin@crosswire.org]On Behalf Of Troy A. Griffitts
> Sent: Wed, December 10, 2003 7:14 PM
> To: sword-devel@crosswire.org
> Subject: [sword-devel] More VBA Help Wanted
>
>
> 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.
>
> _______________________________________________
> sword-devel mailing list
> sword-devel@crosswire.org
> http://www.crosswire.org/mailman/listinfo/sword-devel
>