Page 1 of 2
Using KM with non-english Excel
Posted: Wed Jan 19, 2005 1:42 pm
by shootking
I am using a non-English versions of the Microsoft Excel Analysis ToolPak (and Excel): swedish. It says that I should seek asistance in this forum. Country Code for swedish is 046 (Swedish).
Can I get orund this problem in any way?
Regards Shootking
Posted: Wed Jan 19, 2005 1:43 pm
by The Robman
Do you know what the Swedish versions of the base commands are (ie, DEC2BIN, DEC2HEX, etc) ?
Posted: Wed Jan 19, 2005 1:46 pm
by shootking
No, sorry! I haven't used this functions i Excel at all... But with a little explanation I am sure that I could find out...
Regards Shootking
Posted: Wed Jan 19, 2005 1:55 pm
by The Robman
Try selecting the Help menu option and do a search for "binary" (or whatever that might be in Swedish) as this will most likely bring up many of the base commands in the "3. Chose a topic" section.
Swedish names in toolpak
Posted: Wed Jan 19, 2005 2:18 pm
by shootking
Defined ToolPak Swedish name
Name in KM Function
---------- -------- -----------------
bin_to_dec =BIN2DEC bin.till.dec
bin_to_hex =BIN2HEX bin.till.hex
dec_to_bin =DEC2BIN dec.till.bin
dec_to_hex =DEC2HEX dec.till.hex
hex_to_bin =HEX2BIN hex.till.bin
hex_to_dec =HEX2DEC hex.till.dec
Where should I type in this swedish function names???
Regards Shootking
Posted: Wed Jan 19, 2005 2:37 pm
by The Robman
You shouldn't, Mark Pierson will take care of that for the next release of KM.
Posted: Wed Jan 19, 2005 2:41 pm
by shootking
Oh, great! Guess I have to wait for a while then!
Thanks för your help. Really great!
Regards Shootking
Posted: Wed Jan 19, 2005 3:41 pm
by Mark Pierson
The Swedish function names for country code 046 are already in KM. Are you sure you have the toolpak installed and enabled? If it is, can you tell me what version of Windows and Office you're running so that I can check into it further?
Another thing to check is the language settings for Office. From the Start menu, goto Programs, Microsoft Office, Microsoft Office Tools, Microsoft Office Language Settings, and see what you have for the Enabled Languages as well as the Default Language setting.
Posted: Wed Jan 19, 2005 5:24 pm
by shootking
I have checked the settings in the "Tools" menu, and he "Analysis Toolpak" and the "Analysis Toolpak - VBA" is enabled.
I have checked the language settings in Office too. I have "English (Great Britain)" and "Swedish" as "Enabled Laguages". As default language I have "Swedish". It doesn't matter if I adjust the default language to English, the error message is still appearing.
I am using Windows XP (Swedish) SP2 and Windows Office 2003 (swedish) SP1. I have also tried on my Windows 2000 sp4 with Office 2000 with the same result.
Regards Shootking
Posted: Wed Jan 19, 2005 7:09 pm
by Mark Pierson
Try selecting English (U.S.) as one of the Enabled Languages and that should take care of the problem (be sure Excel is closed when you make the change).
Posted: Thu Jan 20, 2005 10:56 am
by shootking
Got some strange results now...
I still get the error message. But now it states:
find the correct names for these instructions:
bin.till.dec
bin.till.hex
dec.till.bin
dec.till.hex
hex.till.bin
hex.till.dec
These are the correct names for the functions... Very confused right now...
Thanks for helping me out! Really helpful!!!
Regards Shootking
Posted: Thu Jan 20, 2005 3:33 pm
by Mark Pierson
If you still have the zip file, try extracting a fresh copy of KM and try again.
Posted: Thu Jan 20, 2005 4:12 pm
by shootking
I get the same result...
Regards Shootking
Posted: Thu Jan 20, 2005 4:27 pm
by Mark Pierson
shootking wrote:I get the same result...
With these names?:
bin.till.dec
bin.till.hex
dec.till.bin
dec.till.hex
hex.till.bin
hex.till.dec
or the defaults of:
BIN2DEC
BIN2HEX
DEC2BIN
DEC2HEX
HEX2BIN
HEX2DEC
What happens if you close and re-open KM?
Posted: Thu Jan 20, 2005 4:40 pm
by Mark Pierson
Another thing to try... open KM and ignore any errors regarding the toolpak names. Re-save KM (ignore the messages about saving as an .xls). Close KM and try re-opening it to see if it works.