如何使用VBA在Excel中获取用户的语言? [英] How to get the user's language in Excel with VBA?

问题描述

我需要通过VBA在Excel中获得用户的语言，因为Excel不会自动转换数据透视表并且我正在使用 VBA 在数据透视表中进行搜索.

I need to get the user's language in Excel through VBA, as far as Excel does not automatically translate Pivot tables and I am searching within a Pivot with VBA.

仅发现德语中的枢轴是这样的:

Just found out that in German the Pivot looks like this:

在英语中是这样的:

我可以考虑一个选项，在Excel中编写一个 = VLOOKUP()公式，并检查单词是否实际上是"Vlookup".还是它们是 = SVERWEIS()，然后根据结果确定是德语还是英语.

I can think about an option, writing a =VLOOKUP() formula in Excel and checking whether the words are actually "Vlookup" or whether they are =SVERWEIS() and based on the result decide whether it is German or English.

无论如何，这看起来太丑陋".有更好的主意吗?

Anyway, this looks too "ugly". Are there any better ideas?

推荐答案

另一种选择是检查 查看全文