Using KM with non-english Excel

[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

[The Robman]

Do you know what the Swedish versions of the base commands are (ie, DEC2BIN, DEC2HEX, etc) ?

[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

[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.

[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

[The Robman]

You shouldn't, Mark Pierson will take care of that for the next release of KM.

[shootking]

Oh, great! Guess I have to wait for a while then!

Thanks för your help. Really great!

Regards Shootking

[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.

[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

[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).

[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

[Mark Pierson]

If you still have the zip file, try extracting a fresh copy of KM and try again.

[shootking]

I get the same result...

Regards Shootking

[Mark Pierson]

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?

[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.