Test:="Equals" parameter sought for the VBA FIND function that is International (ie., not language specific) RRS feed

  • Question

  • Hi folks,

    I have a VBA macro that uses:

    Function Find([Field], [Test], [Value], [Next], [MatchCase], [FieldID], [TestID]) As Boolean

    Question: Is there a generic value that I can enter for the [Test] parameter so that it would allow my macro to run with any language pack offered by Project ?


    In order for my macro to run successfully in an English version of MS Project I use =>   Test:="Equals".

    But, if I run the macro in an French version of MS Project, I need to use the French equivalent which is =>   Test:= "Égal à".

    If there is no generic value I can use to substitute my current "Equals" string for the [Test] parameter in the FIND, then does anyone know where can I find a list of all the MS Project language equivalents for the string "Equals" for use in this FIND command?  If I had this list, then I am thinking that I could at least try to write a Select/ Case statement to substitute the string value according to the language MS Project is running in.

    Any help would greatly be appreciated

    Thanks in advance,

    Spiro Theopoulos

    Montreal (Quebec), Canada.

    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Sunday, August 4, 2013 12:49 PM


  • I found the solution by setting the argument Test:="" and adding the argument TestID:=pjCompareEquals in my FIND statement.

    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Friday, August 9, 2013 1:36 PM