Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / PowerPoint / July 2006



Tip: Looking for answers? Try searching our database.

Localization

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ecrichlow@gtcocalcomp.com - 18 Jul 2006 19:33 GMT
I have to localize our AddIn. On thw Windows side there are
facilities in VB that make this fairly easy.  In VBA on the Mac side
I'm finidng that these same facilities don't seem to exist.

   Has anybody done localization in VBA on Office (PowerPoint) on the
Mac?

   If so, how did you go about implementing it?

...Thanx...
...Eric...
Steve Rindsberg - 19 Jul 2006 05:40 GMT
> I have to localize our AddIn. On thw Windows side there are
> facilities in VB that make this fairly easy.  In VBA on the Mac side
> I'm finidng that these same facilities don't seem to exist.

VB <> VBA, even under Windows.
In fact there are considerable differences between the implementations of VBA
in different Office versions and between the different Office apps.
Then to add to the fun, Mac VBA, even in the current versions, is more or less
the same as Windows VBA version 5, the version in Office 97.

What specific facilities are you missing?  

================================================
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
ecrichlow@gtcocalcomp.com - 20 Jul 2006 19:28 GMT
Steve,

   Mainly what I'm missing is the ability to read in a resource file
with a set of strings in it and then use LoadResString to populate my
text fields with strings from the proper language.

   Also, there doesn't seem to be any way of determining what the
system language is.

   But I think I've worked around the problem, and, surprisingly, it
seems to have been fairly easy. For what we're doing, I have to have a
native background app running that "communicates" with my AddIn
(through the very low-tech method of creating files whose names serve
as commands that my AddIn periodically looks for.) I've used that
mechanism to have the native app figure out what language the system is
in, and tell the AddIn which language file to read in. Then I wrote my
own simple version of LoadResString to maintain some compatibility with
the Windows AddIn code.

   Only problem now is that Line Input # doesn't seem to be stopping
at a carriage return when it encounters one. And other string
segmenting functions don't seem to be behaving as expected. Hopefully
that won't be too hard to work around. Perhaps I'm just
misunderstanding how they're supposed to work.

...Eric...
Steve Rindsberg - 20 Jul 2006 21:15 GMT
>     Mainly what I'm missing is the ability to read in a resource file
> with a set of strings in it and then use LoadResString to populate my
> text fields with strings from the proper language.

OK.  That's a VBA vs VB thing more than PC/Mac.  

You might instead need to distribute language files in whatever format works
for you.  Read them in at startup or use a function to return the string from
the file as needed.

Ah. And if I'd read all of the reply before starting to babble, I'd have seen
that you did that and then some. <g>

>     Also, there doesn't seem to be any way of determining what the
> system language is.

Sigh.  Yeah.
Application.LanguageSettings .... doesn't seem to be supported.

You might google for Applescript methods of doing this;  you can call
Applescript from within PPT.

>     But I think I've worked around the problem, and, surprisingly, it
> seems to have been fairly easy. For what we're doing, I have to have a
[quoted text clipped - 11 lines]
> that won't be too hard to work around. Perhaps I'm just
> misunderstanding how they're supposed to work.

Haven't run into this one but it may stop at the *system defined* line ending.  
For Windows, CR/LF pairs.  For Mac, CR only, isnt' it?  So you might get lines
that include the LF.

> ....Eric...

================================================
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.