+ Reply to Thread
Results 1 to 13 of 13

Problem between Excel english / french

  1. #1
    Registered User
    Join Date
    08-13-2008
    Location
    Montreal
    Posts
    7

    Problem between Excel english / french

    This is probably a bug, but Im looking for a way to bypass the problem.

    I dynamically (VBA) add dropdown list on top of some cells and set a call to a macro on the OnAction command like this:
    Please Login or Register  to view this content.
    When Excel is in english, no problem, when Excel is in french the OnAction give me an execution error '1004' the formula is to complicated to be affected to the object (translated from french...).

    I suspect that in french the reference "MacroAutoComplete!R1C1:R5C1" is not possible. What should be the universal compatible way to set the reference?

    Thanks.
    ~Ritch

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,222
    Hi Ritch and welcome to the board
    Does the debugger give the line with the RC ref as the wrong one?
    Quoting entire posts clutters the forum and makes threads hard to read !

  3. #3
    Registered User
    Join Date
    08-13-2008
    Location
    Montreal
    Posts
    7
    Yes it highlight this line.

  4. #4
    Registered User
    Join Date
    08-13-2008
    Location
    Montreal
    Posts
    7
    So anyone, any idea?

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,907
    the OnAction property expects a macro name not a range

    what exactly is the code trying to do?
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    08-13-2008
    Location
    Montreal
    Posts
    7
    "MacroAutoComplete" is a Macrosheet 4.0 and "R1C1:R5C1" is the row:column reference where are the macro command on the sheet.

    And dont forget its wokring with english excel version, the problem occur only with french version.

    So maybe there's another way to give the OnAction event the sheet!row:column reference?
    Last edited by Cyberitch; 08-21-2008 at 06:11 PM.

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,907
    I'm too young to know about Macro 4 things

    Sorry I can help.

  8. #8
    Registered User
    Join Date
    08-13-2008
    Location
    Montreal
    Posts
    7
    Quote Originally Posted by Andy Pope View Post
    I'm too young to know about Macro 4 things

    Sorry I can help.

    Gosh now I feel old!!!

    Its ok its very hard to find info about macro 4.0, and if you wanna know, its used for mobile device like pocket pc. Since you cant run (not yet) VBA on mobile device I use those old macro to do some automated actions.

    Is there another way to reference a cell not using R1:C1 ?

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,907
    have you tried using a named range?

    otherwise the only way I know is A1 notation.

  10. #10
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,321
    isnt french equivalent of R1C1 ..... L1C1
    look in tools options general(what that is in french i have no idea)for where youd expect see the use r1c1 reference style

  11. #11
    Registered User
    Join Date
    08-13-2008
    Location
    Montreal
    Posts
    7
    Quote Originally Posted by Andy Pope View Post
    have you tried using a named range?
    Named range?

    Quote Originally Posted by martindwilson View Post
    isnt french equivalent of R1C1 ..... L1C1
    look in tools options general(what that is in french i have no idea)for where youd expect see the use r1c1 reference style
    Yes in tools / options / general / ref style its L1C1 in french, whats that? You mean Excel expect L1 instead of R1?

  12. #12
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,321
    possibly, try it or maybe
    OnAction = "MacroAutoComplete!Cells(1, 1).Cells(5, 1)"

  13. #13
    Registered User
    Join Date
    08-13-2008
    Location
    Montreal
    Posts
    7
    No luck, any other idea I could try?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1