Help w/ Swedish RPC error

[cpnet]

I have an application that automates Excel, to produce reports in the form
of Excel workbooks including Pivot Table and Chart summaries of a
spreadsheet that is loaded from an Access database query. (It's an
application built with Delphi that's doing the automation). This is working
great on hundreds of machines using Excel 97 through 2003. Most of these
machines are using the English or French (Canadian) versions of Windows (95
through XP sp2) and Office.

There are actually about 20 reports that load a query into an Excel
spreadsheet, and then produce an Excel Pivot Table and/or chart based on the
spreadsheet data. Only one of the reports is having a problem for users in
Sweden. (They're using a Swedish version of XP sp1, and for sure Excel
2000 - although some users may have different versions of Excel). When the
Swedish users try to run the report, they get the error:

"RPC kunde inte anropa servern eller kunde inte returnera resultatet av
anropet".

This has been roughly translated for me as, "RPC couldn't call or return the
result of the call".

Because of language barriers, this is tough to track down (I don't speak
Swedish). Is there a place where I can get the exact translation of this
error message to the corresponding English error? Also, I see I can
download the Swedish version of XP (I have an MSDN Universal subscriptioni),
but the 2000 Swedish version of Excel doesn't seem to be available any more.
I do have the English version on CD, but I didn't have a need for the
Swedish version in the past so I never bothered to download it when it was
available. Is there a way I can get this so I can try to reproduce the
problem locally?

Thanks,
cpnet

 

[cpnet]

Some more testing (on Swedish Office 2002 and 2003) has revealed that the
problem isn't about RPC. My automation was adding some calculated fields to
the pivot table in the problem report. The way you write an "if" statement
in Swedish is different than the English syntax in Excel. If you open a
spread sheet authored in one language version of Excel in another language
version, then Excel will automatically translate all the calculations for
you. But, it seems that when actually authoring calcuations (manually or
through automation) you have to use the syntax that matches the version of
Excel that you have. The Office 2002/2003 error messages gave a bit more of
a hint that there was a syntax problem in my sheets (rather than an RPC
error).

So, now I just need to figure out if there's a language-neutral way to write
calculations into an Excel workbook. Otherwise my app is going to have to
detect which language version of Excel is installed, and also know the
appropriate calculation syntax for that language.