Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

OLE ,DELPHI, EXCEL, Language???

Posted on 1998-11-30
6
Medium Priority
?
479 Views
Last Modified: 2010-04-04
Hi,

i'm using delphi 2.0 to write something in Excel.
When i use to english version there are no problems but when someone has the dutch Excel installed all functions are unknown bij OLE. So does this mean i must use the Dutch translation of the function???

I hope not coz then u 've to check if a user uses the french, english, german, dutch, chinese, .... version and then write the code for each country.

If this is the case, where can i find the dutch translation of the english function????

Is there a help-file available or something ??

Please help!!
0
Comment
Question by:rick_mulder
6 Comments
 
LVL 27

Expert Comment

by:BigRat
ID: 1348602
I was intrigued by this question so I ferreted around in the MSDN development library. As far as I can see this should not be necessary, since the names are universal. There is a naming problem between Excel 5 and Excel 7, is that the problem?
   You can also use the ObjectInspector (with Win32 tools) to look at the interfaces in the library, let us know if you find then in Dutch. What names have you used in English?
0
 
LVL 8

Expert Comment

by:ZifNab
ID: 1348603
rick,

 are you talking trough visual basic of Excel?

Zif.
0
 
LVL 44

Accepted Solution

by:
bruintje earned 400 total points
ID: 1348604
Hi Rick,

Guess it's just a coincidence when I tell you my brother has exactly the same name as you.

And for your question, Yes! I've done this a few years back with Office 95. Experienced the same trouble and I do have a list of Excel functions with their Dutch counterparts. It is an Excel sheet and I can mail it to you if you like.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:rick_mulder
ID: 1348605
BigRat, sorry but i don't understand what u mean! Object Inspecter and win32??

Bruintje, please send it to me: rick@no-fear.demon.nl

ZifNab, i'm talking to Excel via delphi in OLE. Most functions are visual basics. Look at the delphi 2.0 autoole demo. There you can see that you need to use a different code 4 each language.

Example

vExcel:=Createobject ('excel.sheet');
vExcel.visible := true;

the command visible works in the english version of excel and not in the dutch version. I've tried it in Excel 7.0 and Excel 97, same result.

The problem is i can't find the translation to the dutch functions.

You must first use the appinfo function to see which version you are using. But coz appinfo is an english command i can't use it in the dutch version!!!!!!

Any suggestion!!


Bruintje, please send the e-mail to me!!
0
 
LVL 44

Expert Comment

by:bruintje
ID: 1348606
Hi Rick,

Well it should be there with you now. I rebuild my Delphi2/Office95 app to Delphi3/Office97 and hate to admit that VBA is grown up to the status of a useful tool.

Good luck.
0
 
LVL 8

Expert Comment

by:ZifNab
ID: 1348607
rick, I know how to talk OLE with delphi and Excel. But if you use visual basic stuff, then YES, you get language problems. Because in Dutch version visual basic is also dutch. But you can change it to english (option in Excel)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Loops Section Overview
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question