Syed23 Posted March 2, 2011 Share Posted March 2, 2011 Hi All, I have createn a tool with the help of Excel.au3 and i am using function _ExcelWriteFormula() to find the average,sum and multiplications. Where this is working fine in English machines but this is unable to write the formula results in other language machines (office also other language) even this is not reporting any error message! any suggesstions would be great! Thank you,Regards,[font="Garamond"][size="4"]K.Syed Ibrahim.[/size][/font] Link to comment Share on other sites More sharing options...
water Posted March 3, 2011 Share Posted March 3, 2011 (edited) Hi Syed23, I once had the same problem and someone on this forum suggested the following solution: ; Set language dependant Excel function (1031 = german) $sEXCElFunction = "=COUNTIF" If $oExcel.LanguageSettings.LanguageID($msoLanguageIDUI) = 1031 Then $sEXCElFunction = "=ZÄHLENWENN" This means to put every needed Excel function into a variable and at the beginning of the script set the variables to the language dependant Excel functions. Edited March 3, 2011 by water My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
Syed23 Posted March 3, 2011 Author Share Posted March 3, 2011 Really sounds cool! i will give a look and update you water! Thanks a lot Thank you,Regards,[font="Garamond"][size="4"]K.Syed Ibrahim.[/size][/font] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now