View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Problems with macro in lang.xls - ProjeQtOr
 

Problems with macro in lang.xls

More
12 Feb 2016 21:54 #1 by tonix
Problems with macro in lang.xls was created by tonix
I'm going to translate some parts of lang.xml, and I'm checking all necessary procedures before.
So, I have problems executing macros in lang.xls, which gave me error.
I'm using openoffice on Windows 7.
And, more strange, I had same error when executing macros using Excel on OSX.
Error is relative to fileDialog function (on line "Set fd = Application.FileDialog(msoFileDialogFolderPicker)").
What do you suggest?

Thanks,

Tonino

Please Log in or Create an account to join the conversation.

More
13 Feb 2016 12:31 #2 by babynus
Replied by babynus on topic Problems with macro in lang.xls
lang.xls macro have been designed to work on wirndows (sorry :blush: )
I had it work in linux quite easily. Just have to avoid all the mso... objects, with are pure Windows objects.
For instance, the msoFileDialogFolderPicker is not mandatory, it is just used to position saving on right place. Just use "save as" before running macro will also work right.
I'll try and retreive the linux version I had.
NB : on linux, macro take about 3mn to complete, and 5s on windows :silly:
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
15 Feb 2016 09:58 #3 by tonix
Replied by tonix on topic Problems with macro in lang.xls
A "Save as" just made before does not work for me, but I solved anyway.
I just put these lines at beginning of function ChooseDirectory()

Function ChooseDirectory() As String
ChooseDirectory = ActiveWorkbook.Path
Exit Function

Now it saves in the same path of xls sheet.

Regards,

Tonino

Please Log in or Create an account to join the conversation.

More
15 Feb 2016 15:57 #4 by tonix
Replied by tonix on topic Problems with macro in lang.xls
Two additional questions.
First question:
change I suggested works, but I have to edit it again each way a start lang.xls. Is there a way to make it permanent?

Second queston:
after generating new lang js files, put them in /tool/i18n/nls I do not see in any way new language in menu (starting draft for italian)? Of course I cleaned cache several times on browser. Is there any furtther operation I should do?
Thanks,
Tonino

Please Log in or Create an account to join the conversation.

More
15 Feb 2016 16:30 #5 by babynus
Replied by babynus on topic Problems with macro in lang.xls

change I suggested works, but I have to edit it again each way a start lang.xls. Is there a way to make it permanent?

Yes, but not as is as it does not work on windows (always saves on Document directory :( )
So a version will be deployed on next version including your proposale condition on the OS.

after generating new lang js files, put them in /tool/i18n/nls I do not see in any way new language in menu (starting draft for italian)? Of course I cleaned cache several times on browser. Is there any furtther operation I should do?

Yes, you have to add new language selection in /model/Parameter.php file, about line 200 where languages are listed (hard coded, sorry)
This makes me think about evolution to dynamically generate lang list... for next version ;)

starting draft for italian

Great news !!! :woohoo:
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
16 Feb 2016 11:56 #6 by tonix
Replied by tonix on topic Problems with macro in lang.xls
Don't worry, general procedure is easy, important is to have a check list.
Thanks,
Tonino

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.043 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form