[sword-devel] More VBA Help Wanted

[Troy A. Griffitts]

Keith,
	Congratulations on your finished semester!  Mine culminates this coming 
Monday.

	I believe all the traffic regarding both VBA projects has been here on 
sword-devel and not in private emails, so unless someone has been 
quietly working on it (which very well may be the case, but hopefully 
your email will bring this to light), then I would say they are both 
still open opportunities! :)

Here's a sample document from the professor:

http://crosswire.org/sword/ALPHAcckswwlkrfre22034820285912/alpha/Lesson5.doc

I'll post the conversion table when I get that, as well.  I don't know 
much of anything about VBA or its capabilities, so your expertise is 
very welcome.

	-Troy.


Keith Ralston wrote:
> 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
>>
> 
> 
> _______________________________________________
> sword-devel mailing list
> sword-devel@crosswire.org
> http://www.crosswire.org/mailman/listinfo/sword-devel