LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Analysis ToolPak Regression Analysis Help Requested MH Excel Worksheet Functions 1 February 28th 09 07:16 AM
Analysis Toolpak-Confidence Level and data analysis questions MH Excel Worksheet Functions 0 January 3rd 09 06:15 PM
List of functions contained in the add-ins, esp. Analysis Toolpak Neil Goldwasser Excel Worksheet Functions 3 January 12th 07 12:43 PM
Why can't I see Analysis Toolpak functions when I have loaded it . Nige Excel Worksheet Functions 6 April 11th 05 11:31 PM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM


All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"