View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default translateIT updated. Autotranslates Analysis Toolpak functions


FYI

I've added a routine to translateIT that updates all analysis toolpak
functions in the activeworkbook from a "foreign" file to local language.

It is a basic search and replace on the error cells in the sheets.
No extensive parsing/verification, (but I do the longer strings
first..). Be aware it's not foolproof, so be sure to verify before
overwiting your original files.

get it here...
http://members.chello.nl/keepitcool/download.html

Let me know what you think.


It's similar to (but a lot faster than) the autolocalize routine in the
ATP translator from Eric Desart at acousticsnoise.com (downloading from
his site has been impossible for months and people were asking for
this functionality)
Ron de bruin is now hosting a copy of the original atptranslator at:
http://www.rondebruin.com/atptranslator.htm



--
keepITcool

| www.XLsupport.com | keepITcool chello nl | amsterdam